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

table importing

ResolvedVersion 2003

David has attended:
Access Introduction course
Access Intermediate course

Table importing

How do you import excel tables to Access

RE: Table importing

Hi David,

Thank you for your question and welcome to the forum.

Open the database and go to File, Get External Data and then Import Data.

Change the Type of file to Excel and select the file and click OK.

Follow the steps of the wizard until a message appears stating that the import has finished.

I hope this answers your question.

Regards

Simon

Thu 17 Sep 2009: Automatically marked as resolved.

Access tip:

Hiding rows and columns

To hide a column or row in Access, you need to minimise the column or row. This can be done by placing your mouse on the right edge of a column, wait for the mouse to change to a double aroow and then drag to minimise the column

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.