microsoft access training course - importing data excel

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training course - Importing data from excel

microsoft access training course - Importing data from excel

resolvedResolved · Low Priority · Version Standard

Olivia has attended:
Access Intermediate course

Importing data from excel

importing

RE: importing data from excel

Hi Olivia

To import information to Access from Excel simply go to:

FILE > GET EXTERNAL DATA > IMPORT

Select the file that you want to import.
Step through the Import Wizard.

If you have any questions about this, feel free to ask further questions.

Regards

Richard


 

Access tip:

Design View in Relationship window

Your in the Relationship window and changes are required to be made to a Table's design.

Rather than exiting the Relationship window, if you perform a right-mouse click on the table, it opens that table up in Design view

View all Access hints and tips


Server loaded in 0.1 secs.