Select Into

[fvd]

Hi There,

I have a example of a query that makes a backup of a table:

SELECT Persons.* INTO Persons IN 'Backup.mdb'
FROM Persons

But i would like to make a copy of ALL of my table's, so i tried something like this:

SELECT * FROM Persons, Inventory INTO Persons, Inventory IN 'Backup.mdb'
FROM Persons, Inventory

But i get an error that says that the syntax isn't correct...
Can somebody help me with this?
Thank you very much!!!

 

[Mile-O]

One destination per query.