# Re: 怎样在同一个mdb档内复制table?

Posted by 小琳 on July 31, 1999 at 20:28:16:

In Reply to: 怎样在同一个mdb档内复制table? posted by kkcheung on July 31, 1999 at 17:37:42:

: 请问怎样在一个mdb内,各复制一个table,(包括内里的资料)

:::使用以下的程式就可以了:
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

P.S.资料表２不要事先建立!!!

Follow Ups: