stevehatpa
Technical User
Hello.
I have created a series of Macros in Microsoft Access 2000 that allows a technology-challegenged client to create exports from underlying SQL data. The final process in the macro creates an Excel spreadsheet toa specified folder on their desktop computer. Since I am using Access 2000 and have over 30,000 records, I must use the TransferSpreadsheet
action in the Macro. But when the export occurs, it creates a newtable that has "ExportError" as the last part of the name. This is due to the fact that the data has "dummy" dates from 1/1/1753. Excel doesn't recognize the dates so it creates the error.
Since I cannot alter the data, is there a simple way to turn off this creation of an error table?
I don't have a lot of experience with Access, so please bear with my lack of knowledge.
Thanks.
-Steve
I have created a series of Macros in Microsoft Access 2000 that allows a technology-challegenged client to create exports from underlying SQL data. The final process in the macro creates an Excel spreadsheet toa specified folder on their desktop computer. Since I am using Access 2000 and have over 30,000 records, I must use the TransferSpreadsheet
action in the Macro. But when the export occurs, it creates a newtable that has "ExportError" as the last part of the name. This is due to the fact that the data has "dummy" dates from 1/1/1753. Excel doesn't recognize the dates so it creates the error.
Since I cannot alter the data, is there a simple way to turn off this creation of an error table?
I don't have a lot of experience with Access, so please bear with my lack of knowledge.
Thanks.
-Steve
