open flat file for output to another file 3

[awelch]

Alright. My simple question is.. How do you open one flat file in this first format then output to another file in another format. I need to loop through the records in the file and at every space write a line(record) to the second file. My files are formatted like this...

abc##12 ab ac ad ae af ag ah ai aj
abc##13 ab ac ad ae af ag ah ai aj

I need to read this in and output to another file formatted like...

abc##12
ab
ac
ad
ae
af
ag
ah
ai
aj
abc##13
ab
ac
ad
ae
af
ag
ah
ai
aj

Any help would be greatly appreciated.

Andrea

 

[strongm]

<fx: blush>

 

[Glasgow]

Late addition to this but if you are processing delimited text files and are &quot;just getting comfortable&quot; with SQL Server 200(0?) db's - if you are not aware of BULK INSERT this is a useful mechanism for importing such text files into the database without any real need for VB code.

 

[CCLINT]

thread222-375073 thread709-292581 thread709-334828

shows also how to do this with text files into JET MDB, which can be modified