S
stevehatpa
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 to
a 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 new
table 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
a technology-challegenged client to create exports from underlying SQL
data. The final process in the macro creates an Excel spreadsheet to
a 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 new
table 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