An easy way to do this be to used a staging table and a stored procedure or insert query. Import the text file into a staging table using DTS...