Loading Access MDB Target from SQL source

[RichWallace]

I have an Access 2000 MDB as my target that I need to populate from a SQL Server Source table. The target tables have columns that are SQL reserved words (Name, Number). How can I perform the INSERTs correctly in my scenario? I receive the following error currently....

WRITER_1_*_1> WRT_8229 Database errors occurred:
FnName: Execute -- [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

When I run the query manually in Access, I have to quote the keywords for it to work of course, so how can I 'trick' Informatica to write to these columns.

 

[RichWallace]

Got it...created an Update Strategy and set my Workflow property on the Target to 'Update as Insert'.