Renaming Excel Worksheets via ADO.NET

[kurious oranj]

I've written a program to extract information from Excel Worksheets
over ado.net and most of it's working fine.

Is there a way to change the sheetname via ado.net?

 

[Paul Clement]

¤ I've written a program to extract information from Excel Worksheets
¤ over ado.net and most of it's working fine.
¤
¤ Is there a way to change the sheetname via ado.net?

No, AFAIK this can only be accomplished using automation with Microsoft Excel.


Paul
~~~~
Microsoft MVP (Visual Basic)