Import from Excel

[JennyL]

Hi,

I splitted my database and trying to import the data from excel to the access. I used to get those confirmation of number of records imported or due to key violation. I no longer get those messages. Anybody know why? Did my table relationship disappear? It seems like access will let me import records to the account table, without a customer id in the customer table. in the past, it will stop me and give me errors.



Thanks,

[ranman256]

you can turn on the warnings, this will let you know how many records.
docmd.setwarnings true.

if you are importing via query, it too will tell you how many records. And you can adjust the fields that get imported.