Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MSQuery does not see the tables in an excel workbook, help.
in excel | import external data | excel driver | selecting a workbook |
MSQuery will open the workbook but can not see any of the sheets as tables. What is missing? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
MSQuery does not see the tables in an excel workbook, help.
Paul
Always best to name the range you want to import (EditNameDefine...) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Paul Wes" <Paul wrote in message ... in excel | import external data | excel driver | selecting a workbook | MSQuery will open the workbook but can not see any of the sheets as tables. What is missing? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
MSQuery does not see the tables in an excel workbook, help.
Nick, Thanks for replying.
have gone through the steps to setup a new data source but there appear to be no tables/sheets appearing in the excel workbook setup as a new data source. Some domino someplace is missing. "Paul Wes" wrote: in excel | import external data | excel driver | selecting a workbook | MSQuery will open the workbook but can not see any of the sheets as tables. What is missing? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
MSQuery does not see the tables in an excel workbook, help.
What version of Excel? Is MS Query installed on your system (you know for a fact)? For Excel 2003: Data Import External Data Import Data... File Type can be either "All Data Sources" or "Excel Files". Navigate to Excel file, select it, click Open, and it should come up. Make sure file is not protected. I just tried a test workbook that I protected and that buggered the process up. -- Air_Cooled_Nut ------------------------------------------------------------------------ Air_Cooled_Nut's Profile: http://www.excelforum.com/member.php...o&userid=15730 View this thread: http://www.excelforum.com/showthread...hreadid=560902 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to stop Excel remembering/loading macro from previously opened Workbook | Excel Discussion (Misc queries) | |||
Excel VBA Merge Workbook tables Central table | Excel Discussion (Misc queries) | |||
custom color palette does not get transferred with the workbook. Excel 2003 | Excel Discussion (Misc queries) | |||
Why does Excel 2003 freeze when saving a workbook that has importe | Excel Worksheet Functions | |||
copy a sheet in same workbook temporary block excel | Excel Worksheet Functions |