ADODB flexible to start on 2nd row?

[demodren]

Hi is anyone familiar with ADODB.Conenction? Is it possinble for it to read the headers from Row 2? I have static data on row 1 which will never change and my actual column headers are on row 2

the code I start with is

  Set objConn = CreateObject("ADODB.Connection")
    strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
              "Data Source= E:\Files\;" & _
              "Extended Properties=""text;HDR=Yes;FMT=Delimited

 

[Andrew Poulsom]

Crosspost:

http://www.excelforum.com/excel-programming/766304-adodb-connection-start-on-2nd-row.html