Insert into from another database

[plus_stick]

Hi everyone.
I'm trying to copy records from another base into existing table in current base by:

DoCmd.RunSQL ("INSERT INTO pivot (RFO_CLIENT_ID, FOLDER_DATE_CREATE, start_time, end_time) SELECT (RFO_CLIENT_ID, FOLDER_DATE_CREATE, start_time, end_time) FROM svod IN 'Z:\NPS\NPS - Operator - 1.accdb' ")

But it doesn't run.
Says insert into syntax error.
Please, correct my code.
Thanks in advance.

 

[pr2-eugin]

Remove the Parentheses after the SELECT and before the FROM Keywords !

 

[plus_stick]

Remove the Parentheses after the SELECT and before the FROM Keywords !

Thanks for your fast reply.
But I've tried it before, same result.

 

[pr2-eugin]

Show the edited code again.

 

[plus_stick]

Show the edited code again.

DoCmd.RunSQL ("INSERT INTO pivot (RFO_CLIENT_ID, FOLDER_DATE_CREATE, start_time, end_time) SELECT RFO_CLIENT_ID, FOLDER_DATE_CREATE, start_time, end_time FROM svod IN 'Z:\NPS\NPS - Operator - 1.accdb' ")

 

[CJ_London]

pivot is a reserved word, try changing the name of your destination table or at least put square brackets around it

 

[plus_stick]

pivot is a reserved word, try changing the name of your destination table or at least put square brackets around it

It works. Thank you very much