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
|