Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Link an Access table or query to an Excel spread sheet

Best of Excel

Link an Access table or query to an Excel spread sheet

by  ETID  Posted    (Edited  )
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.
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top