How to copying from one DB table to another DB table
You can use a SQL statment that appends records from one table to other
(the INSERT INTO ...) command, for accessing another database you can use
the IN clausse, something like : "INSERT INTO tblClient IN "\My
Documents\Databases\new.md" SELECT * FROM tblSource .."
--
Coatl
Alberto Borbolla
Tecnologa en Sistemas
Mexico
(To send e-mail remove the "X" from mail)
Quote:
> How can you copy from one database table to another database table. I
have
> two databases that I like to transfer a copy of the entire table of. Is
> there a fast or easy way to do this?
> If you know of a way, can you email me any examples or tell how to do it?
> PS. I'm using RDO as my database connection method
> --
> Chris Barger
> L3 Communications - Satellite Transmission System
> Digital Systems Division
> Voice (516) 272-5796
