Loading the data from text files

[VBfresher2k5]

Hi All,

I am new vb.net and have a requirement to automate and load the data into sqlserver from the 4 flat files i.e text files which contains in a folder to a respective four tables.

One file data should be stored in one table

Ex: flat1.txt will be stored in table1

flat2.txt will be stored in table2

flat3.txt will be stored in table3

flat4.txt will be stored in table4


The sample data of file contains (There will only one column data) like

1243

1234

2346

3472


Please help..

Thanks for your help in advance!!!!

 

[cjard]

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx

and, the Access (Jet) driver can read text files..
http://www.google.co.uk/search?hl=e...GB260GB260&q=microsoft+text+file+driver&meta=
http://www.google.co.uk/search?hl=en&safe=off&rlz=1T5GGLL_enGB260GB260&q=odbc+text+file+driver&meta=