importing from excel to Access 2003

[Dyanda]

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?

 

[John Nurick]

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.