# 再想问一下.

Posted by kkcheung on August 27, 1999 at 13:06:23:

In Reply to: Re: 请教怎样在同一个mdb内,复制资料表. posted by bmf on August 27, 1999 at 12:14:16:

: : 我想在同一个mdb内,copy 其中一个资料表,存成另一个名称,可以点做.先谢谢.

: Private Sub Command1_Click()
: Dim db As Database
: Dim rs As Recordset

: Set db = DBEngine.Workspaces(0).OpenDatabase(资料库档名)
: db.Execute "select * into 资料表2 from 资料表1"
: End Sub
: 资料表２不要事先建立!!!

如果我每日也执行db.Execute "select * into 资料表2 from 资料表1"
是否先要delete之前的资料表2.可应用什么语法?先谢谢你的回覆.

Follow Ups:

- Re: 再想问一下. Fai 14:31:11 8/27/99 (0)