how to create stored proc to read in flat file, parse it, and create records?

From: NotGiven (noname_at_nonegiven.net)
Date: 06/09/04 

Date: Wed, 9 Jun 2004 14:15:09 -0400

I am relatively new to sqlserver but I have done this in another database
without stored procs.

I want to be able to:
- read in several flat files that contain 1000's of records with fixed
length delimited fields
- parse each field
- create sqlserver records with parsed records/fields

I've written stored procs before but at a loss how to begin on this one.
Any help is much appreciated.

Loading