In your log, you print the value of 23 variables. But you insert 18 values, many of which you don't print in your log. And I don't know what you mean by "your columns look like this". Do you mean you have 6 columns? How can you then insert 18 values? And while 'FIXID' and 'CLIENTNAME' look like column names, '8' and 'fud646_20051118' don't. How do these columns relate to your insert statement? And what relevance does the log have? And where does 'fud646_20051118|' come from anyway?