I've been using Access to export data to Excel all year... this data has been increasing in size as the project nears compleion and now I find that when I export a table (or query) to Excel using the OfficeLinks Tools option "Analyze it with MS Excel" I receive an error message complaining about row limitations. We're only talking about 16,000 - 18,000 rows.
I know that Excel can handle ~64,000 rows when just working within that application. Is there something going on in Access that needs addressing?
Further notes: I'm exporting to Excel so that I can carry out a final review of the data before I convert it to a tab delimited text file, which I then use in an upload tool (for upload into a SAP database). Any option to export direct as a text file? I could then import into Excel...
Using MS Access 2000, Excel 200, XP SP2