SQL Databases: column names with special characters

You should use the AddOnly or Update modes, if you have columns with special characters in their names.

  1. Go to the attribute map of the Update or AddOnly Connector
  2. Rename the Connector attribute (not the work attribute!) from name-with-dash to "name-with-dash" (add quotes).

The necessity of using this functionality might be dependent on the JDBC driver you are using, but standard MS Access 2000 has this problem.

Parent topic: JDBC Connector