Hi all, is there a way for ADODB.Connection to start pulling data where headers are on 2nd row? (I have something static in 1st row) It seems the only way ADODB is working when column headers begin on 1st row.
Thanks so much
![]()
Set objConn = CreateObject("ADODB.Connection") strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source= C:\\Files\;" & _ "Extended Properties=""text;HDR=Yes;FMT=Delimited"""
Bookmarks