When using a SQL ODBC connection to write to a table, that have spaces in the table name, you will get an error.
The solution is to use the Scribe OLE DB adapter to connect to the database.
Use this connection setup:
Data Source = The name of the ODBC to the database
Initial Catalog = The name of the database
User = Name of the user
Password = The password for the user
Additional Connect Parameters: = Blank
Use Owner In Queries: TRUE