Windows Forum

Ask something
Discussion Locked

Linking Excel Workbook to Access Query

0 helpful
3 replies

by john.sarkies

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I would like to be able to link an Excel workbook to a MS Access query. I attempted to use Mircosoft Query which is already built into Excel (DATA | Get External Data | New Database Query), but I can't seem to duplicate the same query as the query I created in MS Access. My MS Access query has several expressions built from multiple tables. Can anyone help with setting up this link to Excel?

3 replies

by dklippert

Use Data>Get External Data. Choose New Database Query and then select MS Access Database*. Find the Target database and yo will be given the option to choose your pre-written Query from that database.

by shanghai sam

This helped me but did not solve my problem completely. What I did not qualify in my problem description was that my database tables in MS Access were actually pulling from SQL. Although my queries were stored on my local drive in MS Access, the actual data source is located on the server in an SQL database.

This discussion is closed to new replies.