access training london - Merging excel into database

Hi Corinne,

Thanks for the question,

You can import data from excel into Access by choosing the option "Create a table by entering data, double click on that so you get an empty page.

Then go File > Get external data > Import data, then a browse option comes up for you to find your spreadsheet and you follow the wizard thereafter.

Good luck

Tracy