Good Day.
I have numerous records that have been handed to me in an excel spreadsheet.
I have been asked to incorporate the data into an existing database. I developed the database but all previous data entry was form/subform based.
I would like to know how to import the data. It does not go into just one table, but rather a few related tables. I thought I could develop a query with the tables and approriate fields and then cut and paste but I have received error messages everywhere (no related record, etc. etc)
There must be an easy way......all help and suggestions are appreciated.
Thanks.
DJ
I have numerous records that have been handed to me in an excel spreadsheet.
I have been asked to incorporate the data into an existing database. I developed the database but all previous data entry was form/subform based.
I would like to know how to import the data. It does not go into just one table, but rather a few related tables. I thought I could develop a query with the tables and approriate fields and then cut and paste but I have received error messages everywhere (no related record, etc. etc)
There must be an easy way......all help and suggestions are appreciated.
Thanks.
DJ
