I am using VS 2008 EXPRESS EDITION and MS SQL 2005 Express edition.
Why is text file handling so frustrating in vb.net?
I have been trying to look up an example of code that would let me import CSV file to MS SQL table.
I want to create a form through which i can enter column names and then by clicking a button i can import respective csv file fields into sql table.
As a beginner i just got lost in the mumbo jumbo of connection strings etc. I could import a csv file in MS SQL using BCP. But how to do it in a vb windows application form by clikin a button in vb.net??
I tried to look up in books , on net i just cudnt find one complete example....as a beginner its hard to understand incomplete examples.