Patrick has attended:
Access Introduction course
Access Intermediate course
Access
How do I import Excel data into a table?
RE: Access
Hi Patrick,
Thank you for your question.
The first thing you need to check is if the Excel data is arranged in columns.
If you want to import data from Excel, then use the File command and then 'Get External Data'. Change the File Type to Excel files. Search for your Excel source and select it. A wizard then begins which will take you through the guided steps.
You will be asked various questions about the Excel data.
I hope this answers your question.
Regards
Simon