Search:

I was given this code to return the Excel Worksheet names from an excel file using SQL's TableSchema..


Dim oledbconn As New OleDbConnection
Dim strConn As String
...

Thanks George..

Its a handy tip..

However that does not help.. I think i didn't give enough info originally..

Clients will be uploading Excel Files on to the Web Server, and a ASP...

I'm using the following code to retrieve data from uploaded Excel Spreadsheets, however the specs we got says "Worksheet named 'Sales' or something simular" .. The sample files we got have 3 names...