Can I use "INSERT INTO" to transfer data from one table to another table?

S

Sean

Hi All,

Both of the table have the same structure. They are the linked table
(connected to SQL Server) too.

Code Example:
DoCmd.RunSQL "INSERT INTO dbo_MSTProduct SELECT * FROM MSTProduct WHERE
IsDirty=-1;"

Can this work?

Thanks!

Best regards,
Sean
 
Top