acFormatXLS => What Excel version?

[wirsing01]

I need to output information to an excel file. Later on I need to re-import this information to an other access97 - database.

So, I exported it using the command
DoCmd.OutputTo acOutputQuery, aqueri, acFormatXLS, ...
This worked fine.
My Problem is:
When I try to import this information back to a database with the command
DoCmd.TransferSpreadsheet acImport,acSpreadsheetTypeExcel97 ...
Access97 tells me, that it is unable to read the fileformat.
After opening the file with Excel and saving it in excel97 format, access97 reads the file perfectly.
Now my question: How can I set that acFormatXLS means excel97 - format?

 

[jflachman]

The OutputTo action should automatically export as Excel 97.
Are you using Excel 97? If you're using a different version, is the file accidentally getting converted to a different version?

What happens if you export the data then immediately try to import it? Jonathan
________________________________________
It is not fair to ask of others what you are unwilling to do yourself.
-Eleanor Roosevelt

 

[wirsing01]

I have only installed Office97.

The error I described, comes up when I export the data and immediately import it to the same DB, as well.

Because I am able to export manually information using the menu point file/export to a excel97 version, i think somewhere must be set, what excel version is created when using acFormatXLS - statement. But where and how can I change this setting?