First I would drop the temp table altogether.

Create a typed dataset with the fields in your text file. Then drop trying to import it directly from the file to the database, read it into the typed dataset, manipulate & format the fields as needed then send the info into there proper tables in the database.