Proper SQL syntax to insert a row to Excel without a header row

[hd95]

I am trying to insert to an Excel 12 spreadsheet through VB/ADO .Net 2.0

Here's my connection string

Dim connectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Book1.xls;Extended Properties=""Excel 12.0;HDR=NO"""
 

This works fine if i have HDR=YES and respectfully named columns in the header row

INSERT INTO [Sheet1$](ColA,ColB,ColC,ColD) VALUES('A','B','C','D')
 

But I want to be able to insert without a header row by just specifying the embedded Excel column names A,B,C etc

Help would be very much appreciated


working code with header:

        Dim connectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Book1.xls;Extended Properties=""Excel 12.0;HDR=YES"""
        Dim factory As DbProviderFactory = DbProviderFactories.GetFactory("System.Data.OleDb")
        Dim Command As DbCommand = factory.CreateCommand
        Dim Connection As DbConnection = factory.CreateConnection()
 
 
        Connection.ConnectionString = connectionString
 
       Command.CommandText = "INSERT INTO [Sheet1$](ColA,ColB,ColC,ColD) VALUES('A','B','C','D')"
 
            Connection.Open()
            Command.Connection = Connection
            Command.ExecuteNonQuery()