Search found 1 match

by johnghng
Thu Apr 28, 2011 6:22 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: csv import into database
Replies: 1
Views: 3221

csv import into database

I have a batch of text files that need to be regularly importe into an sql database
the only strange thing is that there is a header which looks like :
10|2|6/1/2010 12:00:06 PM|PreExistingCond|PreExisting Condition Letter|||D

or

10|4|8/23/2010 1:28:02 PM|DETO|Dependent Over Age Limit|DETO|DETO ...