OutputTo Excel

[brucle]

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?

 

[spacepro]

the error you have stated means this :

Microsoft Access can't save the output data to the file you've selected.@* The file may be open. If so, close it, and then save the output data to the file again.
* If you are using a template, check to make sure the template exists.
* If the file isn't open, check to make sure that you have enough free disk space.@@1@@1


Have you tried to import all of the db objects into a a2K db ?

Andy