Can't import all rows

[Thelaxman]

Hello all,



I apologize if this has been asked before. I've made a database to replace the old one for work and kept the data types the same as before to make the import process the easiest possible. However, when I go to import all of the data (thousands of entries) it will import all data for select entries (i.e. entry 1, 2, 5, 6, 7, 10, 11...). I have tried to export to Excel then import to Access, as well as import straight from the old Access file.

Thank you for any help!

[alansidman]

Are you getting an additional table of the rows not imported with an error message?

[Thelaxman]

It opens a new table and says Paste Error.

[JoeM]

If it is an Access database, why not just import the whole table directly, instead of trying to delete the rows individually?