MSQuery does not see the tables in an excel workbook, help.

P

Paul Wes

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
 
N

Nick Hodge

Paul

Always best to name the range you want to import (Edit>Name>Define...)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
P

Paul Wes

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.
 
A

Air_Cooled_Nut

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top