Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Microsoft: Office FAQ

Best of Excel

Link an Access table or query to an Excel spread sheet by ETID
Posted: 28 Dec 01

In your Excel workbook...

On a blank sheet of your choice choose Data>Get external data>new database query...choose msaccess* database from the databases tab,
find the path to the desired *.mdb and pick your query or table name from the list of tables and querys...(you pick any or all fields at this point) you can skip the next two options or not , (your choice ) but be sure to return data to msexcel
when you successfully return your query data, you can right click any where in the data and choose an update on open option.

Then, every time you open the excel spread sheet, any updated data in the access .mdb will come in.

Back to Microsoft: Office FAQ Index
Back to Microsoft: Office Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close