Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 23-09-2009
Member
 
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?
Reply With Quote
  #2  
Old 23-09-2009
Member
 
Join Date: Jan 2008
Posts: 3,751
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.
Reply With Quote
  #3  
Old 23-09-2009
Member
 
Join Date: May 2008
Posts: 4,565
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.
Reply With Quote
  #4  
Old 23-09-2009
Member
 
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"
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Retrieve data from Access 2007 to Excel 2007"
Thread Thread Starter Forum Replies Last Post
Excel 2007 Data Import via Bloomberg YajasK MS Office Support 2 09-02-2012 07:24 PM
Sort Data disabled in Microsoft Excel 2007 Thedevotee Windows Software 4 13-01-2012 05:24 PM
How to check data validation compatibility of excel 2010 on excel 2007 Zoello Windows Software 6 17-05-2011 10:00 PM
How to set Data Accuracy in Excel 2007 Kaufman Windows Software 4 13-03-2010 12:19 AM
Export excel data to Word 2007 Uzair Windows Software 5 25-02-2010 06:31 PM


All times are GMT +5.5. The time now is 06:01 PM.