Hello guys..:)

 I hv got a problem in accessing the excel files from asp.

 For some reason I need to read the excel files regardless of its sheet names.

 Iam using the ADODB connection to read the excel files.

 Though I can get the sheet contents by using the query

  "SELECT * FROM [sheet1$]"

 I need the sheet1$ dynamic.

 for example
  "SELECT * FROM [sheet(0)]"

 So that even if the sheet name changes I should be able to get the contents in it.

  Any Idea??

  All suggessions will be appreciated.

Thanks



Shibu Narayanan
Software Associates

__________________
Shibu Narayanan
Software Associates

When it comes time to query, it can't be dynamic; you can have the "select * from sheet" string as static, and add the number when you go to query; but when you go to pass it to the database; you have to have a definite sheet number.

Brian

Hi,

There is a way to find out the Active Sheet name at runtime. But that includes Excel COM component. If you can't find any other way to solve it, then you may try to use Excel COM object.



Hope It Helps !!
Bhaskar Ghosh