# Re: 请问SQL如何启用两个资料库(.MDB)

Posted by lijen on December 24, 1998 at 11:22:35:

In Reply to: 请问SQL如何启用两个资料库(.MDB) posted by jan on December 23, 1998 at 11:24:45:

: 在网路上有一1998.MDB的资料库,内有VOU及VOUM两个TABLE
: 在USER端有一C:\TMP.MDB,内有TM1的TABLE

: 请问,我应如何使用SQL语法,才能把VOU的资料丢至TM1中

1. opendatabase 1998.mdb(by ODBC)
2. sqlstring = "insert into tm1 in 'c:\tmp.mdb'
(field1,field2,...)
select fd1,fd2,... from vou
where ....."
3. database_obj.execute sqlstring

Follow Ups: