Can't it replaced the old table instead of creating NEW table? Is there a way out
@LoeblComServices3 күн бұрын
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.
@akokohjoel98543 күн бұрын
@@LoeblComServices thanks for your kind response.
@akokohjoel98543 күн бұрын
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