How do I get ALL of the rows copied in Excel into Access?

[Guest]

When I copy 234 rows from Excel into Acess, only 229 records show up. I
don't know which rows are not getting copied. I dealt with all the not
enough space to copy into the field errors and it still doesn'y copy them
all. Any ideas?

 

[Guest]

This may happen for several reasons. Like for example, if the Access table is
using a multiple field Primary Key and the Excel spreadsheet has 5 rows that
are missing data in one of the key fields. This could happen if you are using
a single field key as well - by the way.
Or
Maybe one of the Access database fields is Numeric and 5 rows in the
spreadsheet contain Alphabetic data for that field (or visa-versa). Try
sorting the Excel spreadsheet column by column. Ascending then descending.
The problem data should rise to the top.

If all else fails, change all of the fields in the Access table into Text
fields, import all the data, then look for the 5 problem rows.

jmonty