Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import Access Data from 3 databases into 1 worksheet *ERROR*
*Using Excel 2007 macro-embedded file (.xlsm), Importing from Access 2007
(.accdb) files* I need to include data from between 1 and 10 access databases, and compile the data into 1 worksheet. The data from Access increases daily (new rows). When I try to refresh the data, it pops up with: This operation is not allowed. The operation is attempting to shift cells in a table on your worksheet. Under External Data Properties, there are 3 options under: If the number of rows in the data range changes upon refresh: --Insert cells for new data, delete unused cells --Insert entire rows for new data, clear unused cells --Overwrite existing cells with new data, clear unused cells I have tried each of those options, but get the same error each time. This is not a problem on worksheets that only need to import 1 data source. I really MUST have one worksheet with this compiled information from 3 sources (for this project). Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error on Refresh Data Import from Access | Excel Discussion (Misc queries) | |||
how to access databases from excel using ms query and odbc? | Excel Discussion (Misc queries) | |||
Security for Viewing MS Access Databases From Excel Datasource | Excel Discussion (Misc queries) | |||
Excel error while trying to import data from an Access database - MSQRY32.exe has generated errors | Excel Discussion (Misc queries) | |||
Import from corporate databases | Excel Discussion (Misc queries) |