Use MS Query to query data within the current work book

S

Steve Kesler

I am trying to use MS Query to retrieve data from an internal Excel Table (or
named range) within the current Excel workbook.

I have it working but I have to point the ODBC data connection to that
actual fixed workbook location on my hard drive.

Connection string: DSN=Excel
Files;DBQ=D:\Data\MLV\MasLoc_View_v1_32.xlsm;DefaultDir=D:\Data\MLV;DriverId=1046;MaxBufferSize=2048;PageTimeout=5;

I would like to set the ODBC connection file to look for the Excel table (or
named range) within the current workbook, and not rely on the fixed location
of the file. Or, I would like to be able to use MS Query to query Internal
data within the current workbook.

Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Connection files and pivot tables 0
Refresh Excel Sheet with Access Data Frequently 0
Access Create Excel Pivot Table Data Source 0
Indexing for data found within a Table Query 2
Relative Path in Connection String 2
Relative path to Access database 2
ADOBE Connection to open Excel workbook 3
Not able to declare variable in MS Query. 2

Top