Click here to Skip to main content
15,895,011 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
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
Posted
Updated 15-May-13 2:43am
v2
Comments
ZurdoDev 15-May-13 7:23am    
Open the text file using the System.File object, parse the data, send it to Access.
Where are you stuck?

this will give you idea..
only you have to change is .Split("|")
and Provider to OLEDB or what ever you are using..
http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/3ce5bb2e-85e9-4116-af6e-3d9c37111282[^]
 
Share this answer
 
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900