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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Format column widths from one table to a separate table on same page 1
Creating a Search using a combo box and then creating a report. 4
Pasting a cell into bookmarked table from excel vba 1
INSERT INTO 1
Replacing a Table with a Table from another database - reference issues 1
Append Access Data to SQL Server Table 12
Update table using data in a different .mdb 0

Top