Hi,
I am not able to read the names of worksheets in an excel file usin sql query, Can anyone suggest any solution.
Using sql statement I am able to read the content of a worksheet but I want to read the names of worksheets.

I havent really used Excel as a datastore, but I would imagine that each worksheet is treated like an individual table. If I am right in assuming this, you could try,

SELECT name
FROM dbo.sysobjects
WHERE xtype = 'U'

But I couldnt be sure that is going to work.