title: Preserve trailing spaces in Access DAO SQL INSERT
body: <p>Am using DAO to insert data into an Access database. When I concatenate fields, trailing spaces are removed. How can I insert data RETAINING trailing spaces?</p>
  
  <p>For example, the following code strips trailing spaces of fields ref and name when creating column "mytext":</p>
  
  <pre><code>INSERT INTO mytest (ref, mytext) SELECT ref, ref + name + '/' FROM mytable
  </code></pre>
  
  <p>mytable is a FoxPro 2.5 table which I have linked. I am assuming the columns in the FoxPro table contain trailing spaces, as my data in FoxPro does not take up the full width of the fields AND in FoxPro when I run a REPLACE including the concatenate operator, trailing spaces DO appear:</p>
  
  <pre><code>REPLACE ALL mytext WITH ref + name
  </code></pre>
  
  <p>Columns "ref" and "name" are character fields of length 10. If ref = "S1" and name = "fred"
  - the command run in FoxPro sets mytext to "S1" then 8 spaces then "fred" then 4 assumed spaces
  - the DAO command run in VB6 sets mytext to "S1fred"</p>