idejjedi2
asked on
Access 2013 - Transfer Table Information From One To Another
Hello Experts,
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...
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...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hey Rey,
You have helped me out in the past and I always thank you for your assistance. I did not follow exactly what you said with the code you summarized above, but you put me on the right track. For future reference for anyone else - I did the following:
1. Imported the excel file to a temporary database table.
2. Converted (if needed) field headers and data types to match the destination table that I want to "append" data to.
3. Opened Query Design and selected the newly created temporary database table.
4. Selected the fields that I wanted to "add" or "append "to the destination table.
5. Selected "Append" in the ribbon and selected the destination table and made sure that all the field names matched accordingly.
6. Ran the query...
I am not sure if their is a better more efficient way, but that is the way I accomplished the task.
You have helped me out in the past and I always thank you for your assistance. I did not follow exactly what you said with the code you summarized above, but you put me on the right track. For future reference for anyone else - I did the following:
1. Imported the excel file to a temporary database table.
2. Converted (if needed) field headers and data types to match the destination table that I want to "append" data to.
3. Opened Query Design and selected the newly created temporary database table.
4. Selected the fields that I wanted to "add" or "append "to the destination table.
5. Selected "Append" in the ribbon and selected the destination table and made sure that all the field names matched accordingly.
6. Ran the query...
I am not sure if their is a better more efficient way, but that is the way I accomplished the task.
following what you outlined above;
are you getting any error? give more detail explanation.
are you getting any error? give more detail explanation.
ASKER
Rey, the steps I outlined above worked perfectly for me. Thanks again for putting me on the right track.
do you need more help?
ASKER
I will always need help with programming. A lifetime learner... :) As far as this question, the steps outlined above worked exactly as I needed. Thanks again.
Hi idejjedi2, Regarding your request for attention ....
Distribute the points as you see fit and if that means giving
all the points to Rey, I will not be in the least offended.
From the wording of your question, I thought you were seeking a non-code solution.
Distribute the points as you see fit and if that means giving
all the points to Rey, I will not be in the least offended.
From the wording of your question, I thought you were seeking a non-code solution.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Then import the CSV file into Access
If this gives you errors, you will have to re-arrange the field order in excel so the data types match up on importing.