I want to transfer data from access to sql.
What I do are :
1. Read Access data and save it to xml.
SELECT DISTINCT FingerPrintID, DateLog, TimeLog, 'ADMINIST', '16/10/2010 22:58:35', 'ADMINIST', '16/10/2010 22:58:35' FROM PersonalLog WHERE DateLog BETWEEN #2010/10/01# AND #2010/10/15#
2. Read xml into datatable and write to sql database.
I get exception :
Incorrect syntax near 'COLLATE'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Sample xml data generated:
What's wrong with my code ?