Import data from closed CSV file using ADO

[YasserKhalil]

Hello everyone
I have this code that imports data from CSV file using ADO ..

Please Login or Register  to view this content.

The csv file name is "SampleCSV" and this file has no headers .. It contains 6 rows from row 1 to row 6
When executing this code it works well but it imports five rows only from row 2 to row 6 skipping row 1
How can I edit the code so as to import row 1 too ... so I need to import the 6 rows (from row 1 to the last row which is row 6)?

Thanks advanced for help

[Norie]

This part of the connection string is telling ADO that the file does have headers, try changing YES to NO.

Please Login or Register  to view this content.

[YasserKhalil]

Thanks a lot Mr. Norie
That is great and awesome ..
You're right HDR stands for Header .. and that worked as expected
Thank you very much