I have designed a database in Access and received 3 Excel sheets from other sources. I want to import data from these Excel sheets (i.e. columns) into some fields in Access which are present in each sheet. Once I have done this, I will use my form to complete the dataset.
This can be done by cutting and pasting but can this be done in another way (to avoid errors?). I am using Microsoft Access 2007 but can use more modern versions.
Thanks for your help,