Access will not import all Excel records

  • Thread starter Thread starter Guest
  • Start date Start date
Access will only import 16383 records out of approximately 45,000
records. Help!!!
Click to expand...

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.

What method are you using?
 
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.

Chris
 
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
 
Back
Top