Hi
I have a 2 tables: One that is empty (access table called Barriers) and one excel table that has records (also called barriers). They have similar fields.
Basically, i want the records from the excel table to be in the access table. I am in the process of populating an empty database from various data sources.
How can i most easily do this? Do the tables need to have matching fields?
Thanks for your help
Sue
I have a 2 tables: One that is empty (access table called Barriers) and one excel table that has records (also called barriers). They have similar fields.
Basically, i want the records from the excel table to be in the access table. I am in the process of populating an empty database from various data sources.
How can i most easily do this? Do the tables need to have matching fields?
Thanks for your help
Sue