|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
I am having an access database with data. This DB contains 4 tables only.
I have now created aother access database with 10 tables. In this new DB, I have 4 old tables but with some new fields also. For e.g. in the old DB, in a table say tab1, i have 3 fields: name, age, sal In the new DB, I hav same tab1 with additional 2 fields : name, age, sal, address, phone I want to insert ONLY DATA of old DB to new DB for the existing tables. Can I do this by any scripting VB or VBA? Anybody can provide me working code for doing this? OR ANY OTHER EASY CORRECT WAY OF DOING THIS.... thanks in advance. |
|
#2
|
|||
|
|||
|
The right way is to link the old tables from the old database to the new database. Then write a query to append from the old tables into the new tables. You could also import the old tables from the old database into the new database, write the append queries and then delete the old tables.
|
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > insert ONLY DATA of old DB to new DB ACCESS |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|