UPSERT query/syntax in OLE DB (MS Access)

UPSERT query/syntax in OLE DB (MS Access)

References

Reference NO 1

http://stackoverflow.com/questions/13642840/upsert-query-syntax-in-ole-db-ms-access

Reference NO 2

http://stackoverflow.com/questions/16948860/error-in-my-sql-statement-upsert

Reference NO 3

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/Q_26433139.html

Reference NO 4

http://support.sas.com/resources/papers/teradata.pdf

Reference NO 5

http://forceamp.com/hats/DBAmpDoc.pdf

Reference NO 6

http://blog.sqlauthority.com/2008/08/28/sql-server-2008-introduction-to-merge-statement-one-statement-for-insert-update-delete/

Reference NO 7

http://www.scribd.com/doc/25520151/DataStage-Connectivity-Guide-for-Microsoft-SQL-Server-and-OLE-DB

Reference NO 8

http://jahaines.blogspot.com/2009_09_01_archive.html