ASP.NET and text files

[JulieL]

Hello all,
My next work package is to process some records from an ASCII text file, which will update SQL database tables.
The text file is a collection of different, fixed length, records identifiable by their first 7 characters.
eg.
0057SIDAZ9BAT25 0659799BATTERY, SECONDARY CEA00000010
0033IIR 34B 2241797U0003699 9999Z
0035CRR W653 9416643 H904 941664399
0035CSS F407 2526355 F407 745033999
0034CDQ O951 T407396PGEA0001 000050
0101DUE01120429 3803071204 F214 991086325000000 221REOBDFAS A22

So first trick is, how do I split this file up into is component pieces, ie all the 0057SID records grouped together, then the 0033IIR records etc etc.

Then I have to process the information in these records, comparing existing data in the database tables with the new data being introduced by this file.

Then finally update the database tables and produce reports of the changes made.

My burning question is, what's the best way to start this particular job.
There is no User intervention required, it's a purely background batch job. The only thing the User does is supply the text file.
I'm working with MS Visual Studio, ASP.NET 2000 and have Crystal V9 as a reporting tool.

I would be very grateful for a kick in the right direction.

Thanks

[kenobewan]

I assume that you would split them, then sort and update in the page load event.