Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access

ResolvedVersion 2003

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

Access tip:

Remove spaces in a table

If you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.