Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel query
I setup an excel query from an excel source. How do I see what excel
worksheet is my source? -- narp |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using A Cell In Excel as Criteria for a Query | Excel Discussion (Misc queries) | |||
Excel 2000 using Web Query is slow on Excel 97 | Excel Discussion (Misc queries) | |||
enable automatic refresh | Excel Worksheet Functions | |||
AHHH! Again | Excel Discussion (Misc queries) | |||
Micosoft Query does not export result set to excel | Excel Worksheet Functions |