Computing.Net > Forums > Database > MS Acess query

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

MS Acess query

Reply to Message Icon

Name: gohome88
Date: January 24, 2008 at 14:45:33 Pacific
OS: WINXP
CPU/Ram: Pentium4
Product: IBM
Comment:

I have 2 Access tables, t1 and t2, they are the same structure but located in different databases. How can I merge these 2 tables and put it back to the databases.

eg.

t1
rec1
rec2
rec3
rec10


t2
rec2
rec3
rec6
rec7

after merge both tables have
rec1
rec2
rec3
rec6
rec7
rec10


Hope here have Access expert can help!!!

gohome88



Sponsored Link
Ads by Google

Response Number 1
Name: Jennifer SUMN
Date: January 28, 2008 at 05:25:58 Pacific
Reply:

File
Get External Data
Import

Just follow the wizard.

Life's more painless for the brainless.


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: MS Acess query

MS Acess - CTRL F box - macro? www.computing.net/answers/dbase/ms-acess-ctrl-f-box-macro/24.html

MS-Access query/report www.computing.net/answers/dbase/msaccess-queryreport/707.html

MS acess at multiple locations www.computing.net/answers/dbase/ms-acess-at-multiple-locations/196.html