How Do I Link Data from an Access Query into Excel?
I Have a Large Amount of Data That I Want Access to Query and Not Bring Everything into Excel. How Do I Save the Query from Access So That Excel Will Recognize...
I have a large amount of data that I want Access to query and not bring everything into Excel.
How do I save the query from Access so that Excel will recognize it as an external source?
1 Answer
You can create a query directly in Access and save it there. If the database is set as an ODBC connection In Excel you can choose DATA> Import External Data> New Database Query> select the database from the list and then the query you saved.
Alternately there are other ways to create the query, but if you are familiar with Access this is a pretty easy way to get the data.
Or are you asking how to store the query itself outside of the Access database as well?
David Miller brings 15 years of experience in global economics, personal finance strategy, and market dynamics. He specializes in turning complex economic trends into actionable insights for everyday readers.
