Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Microsoft Query
I'm am using Microsoft query to return data from a combination of 2 sheets
within the workbook and into a new sheet. How can I control the sql to always find the spreadsheets in the workbook in the current directory? So that if I save the workbook to different location the queries work for the workbook in the new location. At present if I save it back it looks to the old location for the tables. Thanks Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Microsoft Query
Paul Johnson wrote:
How can I control the sql to always find the spreadsheets in the workbook in the current directory? So that if I save the workbook to different location the queries work for the workbook in the new location. At present if I save it back it looks to the old location for the tables. Simply omit the path in the connection string e.g. instead of SELECT * FROM [Excel 8.0;Database=C:\Tempo\Book1.xls;].[A:A]; use SELECT * FROM [Excel 8.0;Database=Book1.xls;].[A:A]; Jamie. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query from microsoft query- Excel 2007 | Excel Discussion (Misc queries) | |||
MICROSOFT QUERY | Excel Worksheet Functions | |||
What is microsoft query? | Excel Discussion (Misc queries) | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
Microsoft Query | Excel Discussion (Misc queries) |