How to create a new sheet in EXCEL-File via OLEDBProvider

  • Thread starter Thread starter Peter Stojkovic
  • Start date Start date
P

Peter Stojkovic

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)
 
Back
Top