Setting the Default Version of Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Analyze with Excel is limited to 16,384 rows regardless of format. Use
File|Export (or DoCmd.TransferSpreadsheet) instead.
 
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.
 
Back
Top