how do i export an access object to another access database

how do i export an access object to another access database

Post by bXZpbmF » Tue, 05 Oct 2004 03:57:01


i have 2 databases, they are templates, both have an object named Employees,
i made the changes to one of the database objects and now want to export
those changes to the other database object. i have tried exporting to excel
and then import to the second database. i get errors doing so. i have tried
exporting to text and then importing. i get errors. i have tried to export
directly to the second database and i am queried if i want to replace. i
select yes but the data does not appear in the second database. what is the
best method for accomplishing what i want to do?
 
 
 

how do i export an access object to another access database

Post by anonymou » Tue, 05 Oct 2004 22:28:24

hi,
try renameing the second employee object before the export.
if that fails, delelet the second employee object before
the export.

object named Employees,
want to export
exporting to excel
doing so. i have tried
have tried to export
want to replace. i
database. what is the

 
 
 

how do i export an access object to another access database

Post by jamiecolli » Wed, 06 Oct 2004 00:12:21

mvinas < XXXX@XXXXX.COM > wrote ...


Where C:\MyTarget.mdb is the database you are copying to:

First, take a backup <g>.

Then:

DROP TABLE [Database=C:\MyTarget.mdb;].Employees;

Then:

SELECT *
INTO [Database=C:\MyTarget.mdb;].Employees;
FROM MyTable;

Jamie.