On Fri, 12 May 2006 10:08:40 +0200, "Peter Stojkovic" <ds*@gmx.net> wrote:
¤ 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/de.../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)