Connecting Tech Pros Worldwide Forums | Help | Site Map

Exporting/Importing a single record from one DB to Another

Stewart Graefner
Guest
 
Posts: n/a
#1: Nov 12 '05
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!

Pieter Linden
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Exporting/Importing a single record from one DB to Another


Stewart Graefner <sgraefner@hfx.eastlink.ca> wrote in message news:<407ef03c$0$205$75868355@news.frii.net>...[color=blue]
> 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[/color]

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.
Closed Thread