Web Development

Ask something
Discussion Locked

Import to SQL 7.0

0 helpful
1 reply

by helen.scheinost

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

1 reply

by madestroitsolutions

Well my friend, if the lines don't have the same number the columns, then how can it be a csv file? In other words, there is nothing you can do, but loop through all the lines with a parsing function.

Good luck!

This discussion is closed to new replies.