Hello!
I want to use the following code
SELECT * INTO Persons_Backup IN ‘Backup.mdb’ FROM Persons
But all I ever get is the error message: "Incorrect syntax near IN"
How could I solve this?
But when I miss the IN clause, it works perfectly.
I think the problem is that I’m not connected to the second database, which I need to copy the data into. But how is it possible to be connected to two databases via one connection string?
Thank you very much!
Loading ...