Parsing Text file w/ multple datasets and schema.ini?
-
so i've been collecting text files with data separated with ';' I have been using a schema.ini file to define each text file...
example:
schema.ini:[text.txt]
Format=Delimited(\;\)
ColNameHeader=False
MaxScanRows=0
Character=OEM
Col1=File Text
Col2=problem Text
Col3=serial Text
Col4=name Text
Col5=cube Text
Col6=time Textdata in text.txt:
ASSET;S/N-BIOS;XXXXXX;DPCSXXX;1KXXX;11/21/2005 5:57:43 AM
now, the data i'm going to be receiving in the the near future has different kinds of data separated by blocks all in the same text file. for example data in text.txt: [AssetData] ASSET;S/N-BIOS;XXXXXX;DPCSXXX;1KXXX;11/21/2005 5:57:43 AM [UserData] XXXX;XX;XX;XX How can I parse this data(previously using a Oledb connection with the schema.ini) into individual datasets? Thanks alot in advanced -- modified at 12:34 Thursday 29th December, 2005