View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Air_Cooled_Nut Air_Cooled_Nut is offline
external usenet poster
 
Posts: 1
Default 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