Hi Larry,
>I don't know about Access but with SQL Server you can deselect the "Use ANSI nulls, paddings and warnings" checkbox in the setup wizard. Unchecking this will make the ODBC driver trim trailing blanks during the send process.
this is a SQL Server specific setting. But even on SQL Server, this setting doesn't prevent the behaviour that was described. A SQL Server table has to be defined while SET ANSI_PADDING is off, in order to trim the blanks. SET ANSI_PADDING OFF has no effect on this when set in a connection where an update or insert is being done.
Regards,
Armin