access
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 » Access

Access

resolvedResolved · Low Priority · Version 2003

replyReply Tue 25 Nov 2008, 16:34Delegate Tsuruko said...

Tsuruko has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course

Access

How to link with Excel files.

For upcoming training course dates see: Pricing & availability

replyReply Tue 25 Nov 2008, 17:15Trainer Simon said...

RE: Access

Hi Tsuruko,

Thank you for your question.

If you want to send data from Access to Excel, select the table or query by clicking once on it and go to Tools, Office Links and Analyse data with Excel.

If you want to import data from Excel into an Access table, you need to go to File - Get External Data - Import... Select the Excel file you want and then follow the steps of the wizard.

I hope this answers your question.

Regards

Simon

 

Please browse our web site to find out more about
access+training and other Microsoft training courses.

Access tip:

Undo Entries In Records

To Undo any entries or changes in records:

Hit the ESC key once for the current field

And ESC twice for current record

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