Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
importing data from Access
I have two mdb's set with macros to import text files, massage the data, and
then export the resulting tables to several worksheets inside two existing Excel files--e.g., the data from Access table "Medicaid Data" gets exported to worksheet "Medicaid_Data" on Radiology.xls using TransferSpreadsheet. I have another worksheet in the Excel file ("Data") that is filled with index/match formulas which point to "Medicaid_Data" so that "Data" serves as the graph datasource and updating "Medicaid_Data" succeeds in updating my graph without my having to rewrite the formulas each month and also keeps the source data with the final report for reference. This worked great last month and in testing.... But now, while one of the Access macros is still behaving as I expected, the other one is now creating new worksheets (e.g., "Medicaid_Data1") rather than replacing the data on "Medicaid_Data". Why am I now getting worksheets added with new names (xxx1) rather than updating the existing worksheet with new data? (And why does it work in one Access/Excel combo but not the other??) With TransferSpreadsheet I have specified: Transfer Type: Export Spreadsheet Type: MS Excel 97 In both cases, I am exporting the contents of Access tables created via Make Table queries. Thanks for any insight! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
importing data from Access
A look at the code would be useful to get an answer. Need the bit where you open the spreadsheet and send the data. Also do you have the spreadsheet used as a linbked table source in the Access database? regards -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=520829 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to use Access data w/o importing it? | Links and Linking in Excel | |||
Importing Data from Access | Excel Discussion (Misc queries) | |||
Importing Data from Access | Excel Programming | |||
Importing Data from Access | Excel Discussion (Misc queries) | |||
importing data from access | Excel Discussion (Misc queries) |