Fixed Width text file to MSDE with C#
I am new to C# and have not programmed since my ALGOL days.
I have been doing a lot of reading, but can not figure out and efficient way to directly import a fixed width text file with 8 fields only separated by their position in the string. Each line in the text file is 420 characters long.
Some of the fields have extraneous \n's in the field so I would like to read them into a MSDE SQL database, separated into separate character fields and work on cleaning up the line feed characters after extracting them from the SQL database.
Thanks for your help,