Table copy

[Thomas Flemming]

Hi,

I like to copy a table with all records to another database.
I found this in sql:

dest_vdb.SqlExecute("INSERT INTO newtbl SELECT * FROM source_vdb.sourcetbl")

But in which syntax do I specify the source-databasefile in this sql?



Regards,
Tom





-- 
/****************************************
**   Dipl.-Ing. Thomas Flemming
**   Software Development
**
**   Touratech AG
**   Auf dem Zimmermann 7-9
**   D-78078 Niedereschach
**
**   mail  tf at ttqv.com
**   fon   +49 (0) 7728 9279-206
**   fax   +49 (0) 7728 9279-29
**
**   http://www.ttqv.com
**   http://www.touratech.de
**
**   ... und immer dem Pfeil nach!
***************************************/