title: MS Access Export via ODBC to Specific DB2 Schema
body: <p>I am trying to export a table from MS Access (2007) to DB2 (9.7 LUW) using ODBC.  I can do this, as long as I export the table into my own schema.</p>
  
  <p>However, I would like to export the table to another schema.  How can I get Access to put the table into another schema?  In Db2, the table <code>foo</code> within schema <code>bar</code> is normally referred to as <code>bar.foo</code>.  However, if I enter this as the target to export to, Access gives me an error:</p>
  
  <p><em>The object name 'bar.foo' you entered doesn't follow Microsoft Access object-naming rules.</em></p>
  
  <p>This is because it won't accept a period in the table name.  Does anyone know how I can overcome this limitation?  I can just copy the table over after the export, but some other users don't have permission to create tables in their own schema; thus, this is preventing them from exporting from Access.</p>
  
  <p>Thanks for your help.</p>