Results 1 to 4 of 4

Thread: Retrieve data from Access 2007 to Excel 2007

  1. #1
    Join Date
    Dec 2008
    Posts
    48

    Retrieve data from Access 2007 to Excel 2007

    Hi,

    I want to retrieve data from Access 2007 to Microsoft Excel 2007 with shared data access. I'll pick regularly data from Access 2007 to Excel 2007 with the "Get external data from Access." It also works fine, but it is pretty rusty, if there are multiple users in Access database, I can not be allowed or if I download data in Excel file so that other users are not allowed to go into the database. The database is designed for multiple users. It seems as if Excel to retrieve data via an undivided data connection. The data retrieved from Access is a question. Is there anyone who can help?

  2. #2
    Join Date
    Jan 2008
    Posts
    3,755

    Re: Retrieve data from Access 2007 to Excel 2007

    If i am not wrong, you download all data from the database. Regardless of how many users can access one database at a time, so data will always be locked while in use. Therefore you can not retrieve data from the database, while having other users on it. When users can usually be more people working or looking in the database, so it can only do so because they do not work in the same data.

  3. #3
    Join Date
    May 2008
    Posts
    4,570

    Re: Retrieve data from Access 2007 to Excel 2007

    You can use Excel 2007 functions directly from Access 2007 by using Automation; you send a request to Excel to perform a calculation with a built-in function and then to return a value to your Access application. See here for more details on this.

  4. #4
    Join Date
    Dec 2008
    Posts
    48

    Re: Retrieve data from Access 2007 to Excel 2007

    I can not get into the database from Excel if there is already a user to log into the database. when i try to access i get this message "You tried to open a database is opened by user 'XX' on machine 'servername'. Try again when the database is unavailable"

Similar Threads

  1. Excel 2007 Data Import via Bloomberg
    By YajasK in forum MS Office Support
    Replies: 2
    Last Post: 09-02-2012, 07:24 PM
  2. Sort Data disabled in Microsoft Excel 2007
    By Thedevotee in forum Windows Software
    Replies: 4
    Last Post: 13-01-2012, 05:24 PM
  3. Replies: 6
    Last Post: 17-05-2011, 10:00 PM
  4. How to set Data Accuracy in Excel 2007
    By Kaufman in forum Windows Software
    Replies: 4
    Last Post: 13-03-2010, 12:19 AM
  5. Export excel data to Word 2007
    By Uzair in forum Windows Software
    Replies: 5
    Last Post: 25-02-2010, 06:31 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,710,827,724.20699 seconds with 17 queries