[AccessD] Import/append into existing table

Heenan, Lambert Lambert.Heenan at AIG.com
Thu Aug 7 10:59:34 CDT 2008


Sure. Just link your additional table temporarily. Then you can run an
append query, adding all the records in the "other' table to the existing
one. After that delete the link to the table.

Lambert 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Thursday, August 07, 2008 11:52 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Import/append into existing table


Hello All,

This is probably a simple question...but can I import a table from 1 mdb
directly into an existing table in another mdb? (kinda like you import an
spreadsheet)

Thanks,

Mark A. Matte
_________________________________________________________________
Reveal your inner athlete and share it with friends on Windows Live.
http://revealyourinnerathlete.windowslive.com?locale=en-us&ocid=TXT_TAGLM_WL
YIA_whichathlete_us
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list