title: ACCESS: Truncation error when appending CSV data to tables?
body: <p>I am currently experiencing difficulties when trying to append data to existing tables.  </p>
  
  <p>I have about 100 CSV files that I would like to create a single table from; all the tables have different column structures but this isn't really an issue as the associated field names are in the first row of each file.  </p>
  
  <p>First, I create a new table from one of the files indicating that my field names are in the first row.  I change the particular fields that have more than 256 characters to memo fields and import the data.  </p>
  
  <p>I then add to the table the fields that are missing. </p>
  
  <p>Now, when I try to append more data, I again select that my field names are in the first row, but now I receive a truncation error for data that is destined for the memo fields.</p>
  
  <p>Why is this error occurring?  Is there a workaround for this?</p>
  
  <p><em><strong>edit</em></strong></p>
  
  <p>Here is an update regarding what I've attempted to solve the problem:</p>
  
  <ol>
  <li><p>Importing and appending tables will not work unless they have the exact same structure.  Moreover, you cannot create a Master table with all fields and properties set, then append all tables to the master.  You still receive truncation errors.</p></li>
  <li><p>I took CodeSlave's advice and attempted to upload the table, set the fields that I needed to be Memo fields, and then append the table.  This worked, but again, the memo fields are not necessarily in the same order in every data file, and I have 1200 data files to import into 24 tables.  Importing the data table by table is just NOT an option for this many tables.</p></li>
  </ol>