OdiN, that was why I suggested using the Temporary Table to import the data and then append the data to the Real table using a Query or VBA Recordset.