N
narp
I setup an excel query from an excel source. How do I see what excel
worksheet is my source?
worksheet is my source?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron Coderre
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
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
N
narp
When I do that is gives me the tab name but not the worksheet file name/path
--
narp
--
narp
Ron Coderre said: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 said:I setup an excel query from an excel source. How do I see what excel
worksheet is my source?