Problem importing EXCEL data into ACCESS

  • Thread starter Thread starter Jerry
  • Start date Start date
J

Jerry

I am trying to import an EXCEL file with about 34000
records into ACCESS. I am using the File|Get External
Data|Import option. There are no error messages and
ACCESS tell me that the file has been successfully
imported, however, it only imports in 16400 of the records.

Does anyone have an idea of what's happening and how I can
fix the problem?

Thanks,

Jerry
 
The Get External Data option uses the old EXCEL 95 format; which cannot
handle more than 16,000+/- records. Use a macro or VBA and run the
TransferSpreadsheet action to import the data; that will allow up to 65536
records.
 
Back
Top