M Reddy

M Reddy

  • NA
  • 1
  • 2.4k

Import Text file data into MS Access Database table using C#

May 21 2013 12:20 AM
Dear Friends,
 
If any one know how to import textfile (Ex - data.txt file) data into MS access database table using c# code.Text file data contain like this below:
 

12|ABC|KOL|WB|REJ|12345678901|12/12/12|123k|12/01/12|200.000|00000000|12/02/12|12000.00|SBI|00000000|12/02/12|12000.00|SBI|00000000|12/02/12|12000.00|UBI|1200000.00|as|12|1000002|e2222|dugdha|dhanbad|12|guj|222|12|12|12|12|11|12|12|12|12|12|12|12|12/12/12|12/12/12 
 
in one row with deliminator  =        |            vertical bar
 

If you have any idea kindly reply me ASAP.
 

Regards
Your Friend