Results 1 to 10 of 10

ADODB connection - start on 2nd row?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-31-2010
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    204

    ADODB connection - start on 2nd row?

    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"""
    Last edited by donyc; 02-28-2011 at 02:31 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1