Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft Access Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old June 18th, 2004, 08:18 AM
Tamrabharani Tamrabharani is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2004
Posts: 1 Tamrabharani User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Question insert ONLY DATA of old DB to new DB ACCESS

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.

Reply With Quote
  #2  
Old June 25th, 2004, 11:49 AM
schroederwallac schroederwallac is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2004
Posts: 7 schroederwallac User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 m 3 sec
Reputation Power: 0
Arrow insert only

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.

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft Access Development > insert ONLY DATA of old DB to new DB ACCESS


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway