Importing a CSV file that has no headers via ADO into VBA

Question

I have an old COBOL system that spits out Simple CSV files. These files have no headers. i.e. all lines in the CSV are data/record sets.

I have the code to import the CSV file into VBA and pop it into an array. All works well but I lose the first line of data because it thinks it is a header row.

the SQL string I am using is SELECT * FROM Data.CSV

Shall I just pull the fields and script a work around or is there a more elegant solution.

thanks in advance for reading this post.

Modify the VBA code so that it doesn't drop the first row, surely. — user1864610
– user1864610, Commented Mar 3, 2015 at 23:54
Have you tried HDR=NO in the extended properties of the connection string? — barrowc
– barrowc, Commented Mar 3, 2015 at 23:56
I have tried HDR= NO but now I'm getting a EOF/BOF error, I get EOF = true and I can't pull the record sets. — Keith Whatling
– Keith Whatling, Commented Mar 4, 2015 at 0:32

barrowc · Accepted Answer · 2015-03-05 22:36:47Z

1

Putting HDR=NO in the extended properties of the connection string should fix that error

answered Mar 5, 2015 at 22:36

barrowc

10.7k2 gold badges47 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Importing a CSV file that has no headers via ADO into VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related