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

Exporting/Importing a single record from one DB to Another

P: n/a
I have been unable to locate anywhere the answer to my problem. I
would like to be able to download/import a single record. This record
is stored in many different related (one to one) tables. I have saved
a single record to Excell and then to a floppy by using a query, to
save the parts of the record I want then "Save as" "Excell". The
problem is being able to take it from the floppy/USB drive and import
it to the same, but in a different location, Data base with its many
related tables. This HAS to be able to be done with a floppy or USB
drive, not email or downloading from a common drive etc.
Thanking you In advance
Stewart

S. Graefner

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Stewart Graefner <sg*******@hfx.eastlink.ca> wrote in message news:<40*********************@news.frii.net>...
I have been unable to locate anywhere the answer to my problem. I
would like to be able to download/import a single record. This record
is stored in many different related (one to one) tables. I have saved
a single record to Excell and then to a floppy by using a query, to
save the parts of the record I want then "Save as" "Excell". The
problem is being able to take it from the floppy/USB drive and import
it to the same, but in a different location, Data base with its many
related tables. This HAS to be able to be done with a floppy or USB
drive, not email or downloading from a common drive etc.
Thanking you In advance
Stewart

S. Graefner


ONE way to do this would be to create an empty copy of your database
(be sure to Compact it) and then import just the tables. Then you
could attach to the destination database (a series of linked tables)
and append from there.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.