reading data from flat file and inserting into sql server 2000 table

[CRP]

I am having a notepad file with pipe(|) symbol. Assume that i have three fields/values in my text file.
The first field is a datefield, the second field is a varchar field and the third one is a numeric/integer field.
Pls give me the full coding in vb.net to read the flatfile and put the contents in the database table each and every row.

e.g
----

2007/23/07|emp04|2345
2007/20/07|emp07|3455

 

[cjard]

have a google for bulk load sqlserver