#1
|
||||
|
||||
Data connection to Access queries and refreshing
Hi
I've connected my excel sheet to 4 separate queries in the same Access database. I did this one at a time via the 'Get Data from Access' button. The data is just inserted as tables in separate tabs in the excel file. I then have a couple of pivot tables based on 2 of the tables. When I refresh the data to reflect changes made in Access, I find I can only refresh one table at at time (right click refresh on one of the list items) - if I try to refresh one of the other tables afterwards I can an error: The query did not run, or the database table could not be opened If I close and save the file, I can then go in again and refresh a different table and it works, but I can still only do one before I have to close and restart. Is this an issue with how I've attached the data? - or some sort of security setting? Thanks for reading! |
#2
|
||||
|
||||
Hi
I just tried setting up an ODBC connection from Excel instead of going down the 'Get Data from Access' route. This seems to work much better! |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Losing data graphics when refreshing external data | Tom_Solen | Visio | 0 | 02-11-2019 04:47 PM |
Macro for automatically refreshing Data connection on Closed excel workbook. | ramzan11b | Excel | 1 | 11-24-2017 08:55 AM |
Merge Object and not displaying Access Queries with VBA | jmo | Word VBA | 11 | 01-07-2016 04:29 PM |
Mailmerge with Access queries | optiontips.in | Mail Merge | 2 | 11-21-2011 03:12 AM |
Refreshing Data in Excel | jamal420 | Office | 3 | 06-13-2005 03:45 PM |