By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,260 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

Export all data from one Access db to another Access db

P: n/a
Hello, I am trying to export all the data from one Access database to
another Access database.

I selected one of my five tables, then clicked "File"-->"Export".
Because my table from database A was going to over-write the table
from database B, I got an error said "You can delete table "xyz"; it
is participating in one or more relationships".

Can someone tell me what is the best way (safe and clean) to export
all data from one Access database to another Access database?

Thank you in advance!
Eddie
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On 13 Sep 2004 14:48:20 -0700, ed********@hotmail.com (eddie wang)
wrote:

Split the database in front-end (everything but tables, and linked
tables) and back-end (tables).
Make a copy of the back-end.

-Tom.

Hello, I am trying to export all the data from one Access database to
another Access database.

I selected one of my five tables, then clicked "File"-->"Export".
Because my table from database A was going to over-write the table
from database B, I got an error said "You can delete table "xyz"; it
is participating in one or more relationships".

Can someone tell me what is the best way (safe and clean) to export
all data from one Access database to another Access database?

Thank you in advance!
Eddie


Nov 13 '05 #2

P: n/a
ed********@hotmail.com (eddie wang) wrote in message news:<87**************************@posting.google. com>...
Hello, I am trying to export all the data from one Access database to
another Access database.

I selected one of my five tables, then clicked "File"-->"Export".
Because my table from database A was going to over-write the table
from database B, I got an error said "You can delete table "xyz"; it
is participating in one or more relationships".

Can someone tell me what is the best way (safe and clean) to export
all data from one Access database to another Access database?

Thank you in advance!
Eddie


link the tables and use append queries
Nov 13 '05 #3

P: n/a
Thank you Tom! It worked..

Eddie

Tom van Stiphout <no*************@cox.net> wrote in message news:<og********************************@4ax.com>. ..
On 13 Sep 2004 14:48:20 -0700, ed********@hotmail.com (eddie wang)
wrote:

Split the database in front-end (everything but tables, and linked
tables) and back-end (tables).
Make a copy of the back-end.

-Tom.

Hello, I am trying to export all the data from one Access database to
another Access database.

I selected one of my five tables, then clicked "File"-->"Export".
Because my table from database A was going to over-write the table
from database B, I got an error said "You can delete table "xyz"; it
is participating in one or more relationships".

Can someone tell me what is the best way (safe and clean) to export
all data from one Access database to another Access database?

Thank you in advance!
Eddie

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.