Problem importing EXCEL data into ACCESS

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
 
K

Ken Snell

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.
 

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.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
You don't currently have permission to access this folder 0
Appending an existing table with imported Excel data 0
Importing XML Data in Access 2003 1
import problems 0
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Importing Excel Data into MS Access Table 2

Top