var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How do I populate empty db table with records from related excel table?
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
Create an append query. Fields don't have to have the same names. It is important that the data types for the fields are set correctly. i.e. number, text, currency.
Hope this helps