Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / August 2005

Tip: Looking for answers? Try searching our database.

Importing Tables

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
CW - 09 Aug 2005 17:56 GMT
I am trying to import tables from one DB to another, but the tables will not
overwrite themselves.  Is there any way to do this?
tina - 10 Aug 2005 00:50 GMT
you might try opening the db that holds the tables, and *export* them to the
other db. a message should come up asking if you want to overwrite, for each
duplicate table name. note:  if there are relationships set up for the
tables in the destination database, Access may not allow an overwrite
(you'll just have to try it and see).

in that case, you might want to open the destination db, link in the tables
from the other db, delete the records from the native tables in the
destination db, and then append the data from the linked tables into the
destination tables.

hth

> I am trying to import tables from one DB to another, but the tables will not
> overwrite themselves.  Is there any way to do this?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.