Lading & Trailing spaces from ODBC table

[davespace]

I import a couple of tables from a proprietary database
with ODBC. Everything works fine except text fields come
over with leading or trailing spaces for those records
that are not filled. What would be the best method for
removing these spaces? TIA

David

 

[Roger Carlson]

Run an Update Query like this:

UPDATE TheTable SET TheField = Trim([TheField]);

 

[John Nurick]

Hi Dave,

Use the VBA Trim() function in an update query.