table importing

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Table importing

Table importing

resolvedResolved · Low Priority · Version 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:

Display current date & time in column of any width

The worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ###

View all Access hints and tips


Server loaded in 0.1 secs.