+ Reply to Thread
Results 1 to 10 of 10

ADODB connection - start on 2nd row?

  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

    Please Login or Register  to view this content.
    Last edited by donyc; 02-28-2011 at 02:31 PM.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,064

    Re: ADODB connection - start on 2nd row?

    Only if you use a specific range address in your select statement.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,064

    Re: ADODB connection - start on 2nd row?

    Just noticed:

    Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

    Read this to understand why we ask you to do this.

    Cross-post here.

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

    Re: ADODB connection - start on 2nd row?

    sorry about the double post.. been trying to find solution for this problem all weeekend.....

    romperstomper..what do you mean when you say only if I use specific address in select statement? does that mean there is a way to specify certain rows for this to be pulled from?

  5. #5
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,064

    Re: ADODB connection - start on 2nd row?

    Yes:
    Please Login or Register  to view this content.
    for example. You can also use named ranges as long as they are not dynamic.

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

    Re: ADODB connection - start on 2nd row?

    I think I screwed up somewhere.. I'm pulling data from a file that changes daily so I added intex function below(it works when headers are on 1st row) i made adjustments as you recommended but am I adding it in the right way?

    Please Login or Register  to view this content.

  7. #7
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,064

    Re: ADODB connection - start on 2nd row?

    It will only work with worksheets, not CSV files (which don't have ranges).

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

    Re: ADODB connection - start on 2nd row?

    ahh makese sense.. so currently i have a code that just deletes the first row for me.. in your opinion..do you think it would be better to to rename the file to .xls to allow to pull on a range? not sure what other limitations csv has

  9. #9
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,064

    Re: ADODB connection - start on 2nd row?

    I'd stick with deleting the first row.

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

    Re: ADODB connection - start on 2nd row?

    cool thanks

+ Reply to Thread

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