Setting the Default Version of Excel

[Guest]

I need to tell Access to use a more current version of excel when doing
various exports to Excel. I am running both 97 and 2000. When I do the
Analize with Excel the default version of Excel linits me to 16K lines. I
need to set the default to Excel 97 so I don't get the dreaded too manky rows
message at 17K lines of output.

 

[John Nurick]

Analyze with Excel is limited to 16,384 rows regardless of format. Use
File|Export (or DoCmd.TransferSpreadsheet) instead.

 

[Guest]

If you are using the TransferSpreadsheet method, you can identify the Excel
version in the second argument. If you are doing it using the menu bar
(File->Export), you can identify the version in the Save As Type drop down.
If you are using VBA, you will have to use late binding.