ADODB connection - start on 2nd row?

[donyc]

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.

[romperstomper]

Only if you use a specific range address in your select statement.

[romperstomper]

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.

[donyc]

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?

[romperstomper]

Yes:

Please Login or Register  to view this content.

for example. You can also use named ranges as long as they are not dynamic.

[donyc]

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.

[romperstomper]

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

[donyc]

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

[romperstomper]

I'd stick with deleting the first row.

[donyc]

cool thanks