I am importing data from an EXCEL     XLS-File via OLEDB-Provider

The command is SELECT * from [sheet1]


Everything works fine if the first sheet is named sheet1



How can a create a new sheet inside the XLS-File

What command I must program ??

¤ I am importing data from an EXCEL     XLS-File via OLEDB-Provider
¤
¤ The command is SELECT * from [sheet1]
¤
¤
¤ Everything works fine if the first sheet is named sheet1
¤
¤
¤
¤ How can a create a new sheet inside the XLS-File
¤
¤ What command I must program ??

Open a connection to the Excel Workbook and try using Jet SQL DDL:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acfundsql.asp

Keep in mind there will be some limitations since you're working with an Excel Workbook and not an
Access database.


Paul
~~~~
Microsoft MVP (Visual Basic)

Multiple fields in a single textbox
Image Resource - not released
DataViews with DataSets
Reading and Writing Text Files
Sending an Email from .net?
How to import always the FIRST available sheet from EXCEL-File
Closing all forms at once
Inherent encryption in .NET 2.0?
dot.net com class function
Copy HTML Table To CSV