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

access

ResolvedVersion 2003

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

Access

How to link with Excel files.

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

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

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.