I created a database in Access97. I have a report that is exported to Excel 97 with the following code
DoCmd.OutputTo acOutputReport, "Outstanding No Stocks Query1", acFormatXLS, "C:\NoStocks.xls", True
This works well on my system (Win2k and Ac97) However, I copied the local database (in Acc97 format) for use in several remote warehouses. The users there all have WinXP and Access2002.
The database works well for them except when they try to export the report they get this message:
Run time Error 2302:
Can't save the data to the output file you selected.
I am assuming either Access 2002 or Excel 2002 handles this OutputTo function differently.
At present they are manually exporting the file to Excel. Does anyone know how to fix this and get the automatic export to run?
DoCmd.OutputTo acOutputReport, "Outstanding No Stocks Query1", acFormatXLS, "C:\NoStocks.xls", True
This works well on my system (Win2k and Ac97) However, I copied the local database (in Acc97 format) for use in several remote warehouses. The users there all have WinXP and Access2002.
The database works well for them except when they try to export the report they get this message:
Run time Error 2302:
Can't save the data to the output file you selected.
I am assuming either Access 2002 or Excel 2002 handles this OutputTo function differently.
At present they are manually exporting the file to Excel. Does anyone know how to fix this and get the automatic export to run?