I believe some of the methods for interacting with Excel assume the older Excel
file format that was limited to around 16000 rows. Other methods do not have
this problem.
I found this from a previous post. Maybe it will help.
This means you are importing to the old Excel format with
its limit of 16k rows. This automatically happens if you use
Analyze it with Excel
DoCmd.OutputTo or the OutputTo macro action
Avoid it by using File/Export or DoCmd.TransferSpreadsheet
and the Excel 97 or later (version 8 or later) file format.
I've never heard of the 16384-row limit of older version of Excel
applying to data being *imported*, and it seems inherently unlikely.
Troubleshooting steps:
1) Is there any error message or Import Errors table?
2) Identify which records are being imported and which not.
3) If the first 16383 are being imported and the remainder ignored, look
for something different at record 16384. If it's that some records are
imported and others ignored throughout the Excel table, identify what
the two groups of record have in common.
Hello, John,
FYI
I was struggling with import a large spreadsheet. Thanks to a note I read
here, I did not check the have the wizard analyze imported and the import
worked with no problems. YEAH!
Have a great day,
Lynne
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
