I am trying to import a CSV file into MS Access and on all the AutoNumber Fields it denies it due to policy error.
I have a SKUs table and I am importing records into it. One field in the SKUs table is called ManuID. It is a field for a Manufactures name like GENERAL ELECTRIC.
I have a Manufactures table called Manufactures. General Electric is AutoNumber / ManuID 620.
I have 1000s of records to import. How can I do this. Thanks.