importing from excel to Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am importing 4800 records (4 fields) from excel to access 2003 and every
time it is trucating my data and only importing 2404 records. Does anyone
have any suggestions?
 
Hi Dyanda,

Do you mean that it's importing only the first 2404 rows of the Excel
data and leaving the remainder? If so, look for a change in the data or
formatting between the 2404th and 2405th rows (e.g. a non-numeric value
in a column that has hitherto contained only numbers).

If it's importing some rows but not others, identify the difference
between them.

Also, if you're importing a named range, make certain that the range
covers the range you want to import.
 
Back
Top