paulcraigdainty
Registered User.
- Local time
- Today, 08:15
- Joined
- Sep 25, 2004
- Messages
- 74
I have a number of databases that all export data to Excel spreadsheets. Using the following:
DoCmd.OutputTo acOutputTable, "tblFault", acFormatXLS, "G:\\FaultLogReport.xls"
Application.FollowHyperlink "G:\FaultLogReport.xls"
What i want are the individual databases to export and update the same spreadsheet. I have tried pointing the code in each database to the same .xls however each time i run the code and export the data it overwrites what has been previously exported rather than adding more rows into the spreadsheet.
I have tried searching the forum but can't find anything. Does anyone know if this is possible?
DoCmd.OutputTo acOutputTable, "tblFault", acFormatXLS, "G:\\FaultLogReport.xls"
Application.FollowHyperlink "G:\FaultLogReport.xls"
What i want are the individual databases to export and update the same spreadsheet. I have tried pointing the code in each database to the same .xls however each time i run the code and export the data it overwrites what has been previously exported rather than adding more rows into the spreadsheet.
I have tried searching the forum but can't find anything. Does anyone know if this is possible?
