storing data from a .txt file into SQL database

[inayat basha]

i have an text file with some data. i want load the text file in mu sql server 2005 database by using vb.net. can any one plzz help me... Regards, S.Inayat Basha.

[Gamzun]

Open the file, read text from it and store it into database. Do you want us to develop it for you?

Please don't forget to mark 'Good Answer', if you find it really a good one! Kashif

[Kannan Ar]

Open the file and read content using the classes in System.IO, then insert it into sql server. What you tried to accomplish this?

[loyal ginger]

If the text file is already in proper format, use this:

load data local infile "my_data.txt" into table my_table;

[inayat basha]

can u plz send me the code for it....

[Gamzun]

At least give it a try! First search on google how to open up a file then google for reading it and then for inserting into db.

Please don't forget to mark 'Good Answer', if you find it really a good one! Kashif