Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export from Access to Excel
I built an Access database which exports the daliy (new) figures to Excel to
the desktop. One of the queries is for pulling all the information for a Credit Manager (CM). I then need to link this data to a summary Spreadsheet. So each day I want to go to my database, pick the CM's data, export and replace the old info with the new, and keep the links I have created when I exported the first one. When I exported the first, I linked it to a number of spreadsheets. Any thoughts? I get an error telling me that "It cannot expand the named range". If I rename it then I would have to reset all my links. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export to Access from Excel | Excel Discussion (Misc queries) | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
export data from Excel to MS Access (ADO) using VBA | Excel Programming | |||
Export from Access to Excel | Excel Discussion (Misc queries) | |||
Programming Excel to export to Access | Excel Programming |