By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,490 Members | 1,753 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,490 IT Pros & Developers. It's quick & easy.

copy data from one database to another database

P: 1
I run an Access-based application that uses main1.mdb (updated weekly). However going forward I would only receive main2.mdb file with different structure. My question is how I can copy data from main2.mdb file into main1.mdb. The main1.mdb had 5 tables and main2.mdb has 9 tables (5 tables similar to ones in main1.mdb + 4 new tables). The good news is that I donít need to use the data from 4 new tables. However few columns have been renamed or dropped in the original 5 tables.

I have posted 2 tables with the understanding that if someone can help me with these 2 tables, I can make relevant changes to other three tables. As you can from the following example that there is a one-to-one relation between Administrative and Access table (with column names renamed)

Main1.mdb

Administrative
AdCode
AdName
AdDesc
AdDate

Access
AcNum
AcDate


Main2.mdb

Administrative
Ad_Id
Ad_Name
Ad_Bit (New Column Name)
Ad_Desc
Ad_Date

Access
Ac_Num
Ac_Date

Any help will be highly appreciated.
Jun 29 '09 #1

✓ answered by ajalwaysus

I'm not completely sure I know what you want, but if you are simply trying to transfer data from one MDB to another. A simple way, would be to just link the tables from Main2.mdb in Main1.mdb. Then just create a simple query that takes from Ac_Num and insert into AcNum..etc.Hope this helps.

Share this Question
Share on Google+
2 Replies


yarbrough40
100+
P: 320
I have read your question a few times and I'm still confused at what you are asking. Are you wanting to simply send data from tables in Main2 to tables in Main1? Are you wanting to do this one time... or do you need a code solution so that you can run updates periodically?
Jul 6 '09 #2

Expert 100+
P: 266
I'm not completely sure I know what you want, but if you are simply trying to transfer data from one MDB to another. A simple way, would be to just link the tables from Main2.mdb in Main1.mdb. Then just create a simple query that takes from Ac_Num and insert into AcNum..etc.Hope this helps.
Jul 17 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.