Append query

[markwakelin]

I am trying to append data in one database to another, both databases have a database password..
This is my SQL

INSERT INTO [;PWD=driftwood].AcceptedPayment IN 'C:\TO.mdb'[;PWD=driftwood]
SELECT AcceptedPayment.* FROM AcceptedPayment

When i try and run this i get "Syntax Error In Insert Statement" and the cursor gors to 'IN'..
Any ideas on what i am doing wrong ??

Mark