When the SQL Builder is used to create an INSERT statement, it automatically labels each column as table_name.column_name.
Some data sources such as Microsoft Access can understand column names in an INSERT statement that are labeled as column_name but not those labeled as table_name.column_name. Testing an INSERT statement in the SQL Builder will generate an error message from the data source about an "invalid column name".
To test an SQL Statement for this type of data source, you must:
Click Save to paste the INSERT statement into the SQL statement box on Step 2 of the Database Integration Wizard.
Edit the text in the SQL statement box to remove the table_name and the period from each instance of table_name.column_name.
On Step 2 of the Database Integration Wizard, click Execute query to test the INSERT statement.