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