# Re : 补充几点说明 ...

Posted by 安宝 on April 12, 1999 at 11:45:40:

In Reply to: Re: 各位高手救救我吧!!!资料库查询存档问题... posted by 纪文和 on April 10, 1999 at 05:05:47:

补充几点说明 :

不管应用系统原来使用的资料库是那一种 (Oralce/Access/SQL Server..)
SQL语法正确但程式执行方式则随使用资料库形态而有所差异哦 !

SQL =" INSERT INTO target " & _
"[IN externaldatabase] [(field1[, field2[, ...]])]" & _
"SELECT [source.]field1[, field2[, ...]" & _
"FROM tableexpression "
1. Access & SQL : dbs.Execute SQL$;

2. Oracle : dbs.DbExecuteSQL (SQL$)

Follow Ups: