How To Use Access VBA To Copy A Table With DoCmd.CopyObject

[@akokohjoel9854]

Can't it replaced the old table instead of creating NEW table? Is there a way out

[@LoeblComServices]

Hi, when you copy a table, it will automatically receive a "1" at the end of it's name. You will have to delete the old table first and then copy the table so you don't have this happen.

[@akokohjoel9854]

@@LoeblComServices thanks for your kind response.

[@akokohjoel9854]

Pls kindly assist me, I have a table named tbproduct and and table tbstock,. How can I copy the BULK data from tbproduct to tbstock base on criteria or condition with VBA? Pls 🙏

[@LoeblComServices]

@@akokohjoel9854 one approach you can use if to build 2 queries. Query1 would be to select from tblProduct what you would like to append to tblStock. Then append Query1 to tblStock