# Re: 如何将一个recordset的资料抄到另一个资料表?

Posted by AndyLin on November 11, 1998 at 15:59:10:

In Reply to: 如何将一个recordset的资料抄到另一个资料表? posted by kkcheung on November 11, 1998 at 15:14:15:

: 如有一个recordset想将每笔资料的其中一此fileds抄到
: c:\temp\temp.mdb的test内,应该在程式中怎样做,
: 我看过 insert into [资料表] vaslues (fields1,fields2....)
: 祥细怎样希望大家指教.

insert into tablename1(filedA1,fieldB1...) select fieldA2,fieldB2... from tablename2

Follow Ups: