I am currently trying to import a csv file into a sql server 7.0 database using Visual Basic. The problem is that the lines in the file don’t all have the same number of columns, thus BCP won’t work, and looping through each row takes too long.
Any suggestions?
