View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default How to accsees excel file from ODBC if file has no tablename?

In the query wizard's "Choose Columns" page
there's an option button....

Check to display system objects,
that'll enable you'll see sheetnames.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Eugene" wrote: