Copying access tables to a central access database
i need to know how to copy, through code, several tables from different access databases scattered over the network to a central access database. i need the tables to be overwritten during the copy operation. i was hoping this could be done through sql. any help is greatly appreciated.