lundi 23 février 2015

How to read a delimited txt file and populate my database? - C# WindowsForms

I'm building an app that needs to read a delimited text file and populate some table in my database (SQL Server) with these data.


I've set the delimiter as: ¬


An example of data inside the file that I need to import:


OLD_CLASS¬OLD_NUM¬OLD_SUB_NUM¬NEW_CLASS¬NEW_NUM¬NEW_SUB_NUM ZETMODEM¬750000595588¬0¬ZETMODEM¬710000003092¬0 ZETMODEM¬750000991145¬0¬ZETMODEM¬750000003980¬0 ZETMODEM¬750000570809¬0¬ZETMODEM¬710000003092¬0 ZETMODEM¬750000493550¬0¬ZETMODEM¬750000000001¬0


What is the best (easier) way to do this?


Thanks!


Aucun commentaire:

Enregistrer un commentaire