microsoft access courses - importing data excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access courses - Importing Data from Excel

microsoft access courses - Importing Data from Excel

resolvedResolved · Low Priority · Version Standard

replyReply Tue 26 Jun 2007, 09:46Delegate Laura said...

Laura has attended:
Access Intermediate course

Importing Data from Excel

How do you import data from excel?

For upcoming training course dates see: Pricing & availability

replyReply Fri 29 Jun 2007, 15:19Trainer Amanda said...

RE: Importing Data from Excel

Hi Laura

Thanks for your question.

Use File - Get External Data - Import to bring Excel data into Access.

Amanda

 

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard