I have a fixed length text file that I wish to import into SQL tables.

The text file will contain 2 different types of records. Firstly, a
header record, which is immediately followed by X number of detail
records.

Each record is 80 characters long, separated by a CRLF, and the type
of record is identified at the beginning (first 2 char's).

I would like to insert the header records into a header table,
returning the unique ID (auto incrementing ID) of the row inserted
into the header table, which will be used when inserting the
associated detail records.

Does anybody have any sample ActiveX scripts that do something similar
to the above?

Basically, I'm after an example script that opens a file, loops around
each row in the file and tests the data in some means.

Any examples would be absolutely fantastic and much appreciated!

Many thanks

Anthony

I am looking for the same thing and would be interested if you found a
solution. I am new to SQL server/DTS and want to do a similar thing.

We have 3 record types in one file and each one needs to go to it's own table.

I think I can code this in an ActiveX script, but I need to figure out how
to define columns in a TEXT file for each reacord type HDR_COL1, HDR_COL2,
DET_COL1, DET_COL2, etc.

That is where I am hung up now.

"Anthony" wrote: