View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mircea Pleteriu[_2_] Mircea Pleteriu[_2_] is offline
external usenet poster
 
Posts: 17
Default Get worksheet names

I got it by means of OleDbConnectionGetOleDbSchemaTable method.

"Mircea Pleteriu" wrote in message
...
Hi,

I use the OleDb objects to connect to an excel file and retrieve data from

a
specified worsheet.

What SELECT statement should I use (if there is an existing one) to

retrieve
the names of the worksheets in the file?

Thanks,
Mircea