Access 2013 - Transfer Table Information From One To Another
Posted on 2015-02-24
I am new to MS Access 2013 and have so far built a Master List table. Periodically, I need to add 20 - 25 new records to the end of the Master List table. Basically like adding new customers to the end of a customer table. I am looking for a simple, safe and reliable method to import, export, copy or transfer these new 25 records into the Master File table without manually entering the data. The data is currently given to me by a colleague in an excel format. I have tried importing excel file and appending to end of Master List table. It gives me a number of errors. I then created a new temporary access table and attempted to copy, import and export with little success. Keep in mind, I am somewhat new to Access and have been teaching myself. I am not currently at the level of using macros or code to accomplish this task (if possible). As I stated earlier, I am under the assumption that their is a simple, safe and reliable method for adding or appending this data to the bottom of my Master List table. Thanks...