After much frustration at trying to do it myself, I have loaded the KBCsv library into Visual Studio2010 and have been trying to give it a go.
From all I read, it appears to do exactly what I want! This is my first VB project and I'm kinda learning as a go.
However, I'm a little stuck. I can't see any VB code samples to see how it is used in VB. I'm particularly keen to establish
1. how to open the file
2. how to read in the header row (because some of my 100+ CSV's dont have the correct headings)
3. how I can process each line (a little bit of logic and squirting the data off to a SQL database
Can anyone help? It appears there is plenty of C examples. I can't even find the methods. Please dont laugh at me :)
Any help you could give would be much appreciated.