Quote Originally Posted by Hack
That doesn't make any sense. If your INSERT has the right values, then those values should be what is getting back to the database.

Put a break right after the .Execute and send it through a multi-record insert loop.

After each insert look at the new record in the table.

Keep the debug.print in place for the insert.

Tell me what you see in the table after each individual insert.
Thanks Hack

I will have to do this tomorrow, but I will definately post back.