Hi, I'm creating an import module to read data from old textfiles, run some
calculations on them and save them to sql server. I've figured out how to do
a select on textfile using a schema.ini file (my textfile is delimeted by a
| )
But I've got on problem remaining, below you can so two example rows out of
the textfile:
560000||TS|alu dak|0000000067|P400|20|7101|401|0|0|0|0|||||N|J
560039||KM|"De Gaer":
Partoens-Nijs|0000009001|P400|20|54|401|0|0|0|0|||||N|J
The first row is handled just fine, but if I read the second row into a
dataset, I get all NULLS after "De gaer", it doesn't read "De Gaer":
Partoens-Nijs as one column, it seems to trip on the "". Any hint or tip is
much appreciated. I also posted my connectionstring and schema.ini file
below.
Thanks in advance greetz Peter
Private ConStr As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
"c:\;Extended Properties=""Text;HDR=No;FMT=Delimited\"""
Private conn As New OleDb.OleDbConnection(ConStr)
[TR028C.TXT]
ColNameHeader=False
CharacterSet=ANSI
Format=Delimited(|)
Col1=offnr Text
Col2=datum DateTime
Col3=calcu text
Col4=refer text
Col5=kltnr text
Col6=sercode text
Col7=kcode text
Col8=gcode text
Col9=ktype text
Col10=rp text
Col11=gp text
Col12=ri text
Col13=kw text
Col14=varia text
Col15=adrnr text
Col16=cdlev text
Col17=cdbet text
Col18=pt text
Col19=ofbev text