Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding tables in a query
I wish to add and link multiple tables using Query in Excel 2003. These
tables are on different Excel workbooks. In the Query window, when I click on the Add Tables button, only the tables from the workbook I selected on the Select Workbook form will show up. When I go to Data, New Database Query, and double-click on <New Database, I may add several workbooks as data sources. Even so, my new sources won't appear on the Add Tables listing. I think I read somewhere in the Help that all workbooks should be located in the same folder, but this doesn't make any difference. And I don't think I can designate a folder as data source (or can I ?). The only way I can succeed so far is by copying and moving all required worksheets into one master workbook. This is not very practical. Any suggestions ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Query Outer join with three tables | Excel Discussion (Misc queries) | |||
How import multiple tables from same web page (Web Query)? | Excel Discussion (Misc queries) | |||
MS Query No visible tables | Excel Discussion (Misc queries) | |||
Web Query from multiple tables | Excel Discussion (Misc queries) | |||
Two Excel tables in MS Query | Excel Discussion (Misc queries) |