how do i export an access object to another access database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
hi,
try renameing the second employee object before the export.
if that fails, delelet the second employee object before
the export.
 
mvinas said:
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?
Click to expand...

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.

--
 
Back
Top