excel query
 

I setup an excel query from an excel source. How do I see what excel
worksheet is my source?
--
narp

excel query
 

Try this:

Right-click on the data table
Select: Edit Query
When MS Query opens, click the [SQL] button
Is the complete file path displayed in the SQL?

Example:
SELECT rngMyData.Name, rngMyData.Year, rngMyData.Amounts
FROM `C:\Data\TestExcelList`.rngMyData rngMyData

In that, case the source file is:
C:\Data\TestExcelList.xls

Note: MS Query truncates the xls file extension

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"narp" wrote:

I setup an excel query from an excel source. How do I see what excel
worksheet is my source?
--
narp

excel query
 

When I do that is gives me the tab name but not the worksheet file name/path
--
narp


"Ron Coderre" wrote:

Try this:

Right-click on the data table
Select: Edit Query
When MS Query opens, click the [SQL] button
Is the complete file path displayed in the SQL?

Example:
SELECT rngMyData.Name, rngMyData.Year, rngMyData.Amounts
FROM `C:\Data\TestExcelList`.rngMyData rngMyData

In that, case the source file is:
C:\Data\TestExcelList.xls

Note: MS Query truncates the xls file extension

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"narp" wrote:

I setup an excel query from an excel source. How do I see what excel
worksheet is my source?
--
narp