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

Download/Importing a single Access record from a removeable data media ie 3.5" disk or USB drive

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
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On 29 Feb 2004 16:09:24 -0800, sg*******@hfx.eastlink.ca (S. Graefner) wrote:
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


I recommend using DoCmd.TransferSpreasheet to import the Excel data into a
temporary table, then use and AppendOnly Dynaset recordset to insert the first
row, and read the Autonumber key assigned to the row, then use recordsets or
insert queries to insert data into the related tables with the same key
derived from the first insert.
Nov 12 '05 #2

P: n/a
If you are transporting between 2 mdb files, why don't you create a
transport mdb file linking to the external database. You can then copy the
record to a local table and close the application. Then take the floppy to
the new system. Open the application, relink to the new external database
and write the record from your local tables. I did this with a quoting
application to allow the sales department to quote offsite and then transfer
the data to the main system when they returned. It has been running since
Access 2.

"S. Graefner" <sg*******@hfx.eastlink.ca> wrote in message
news:fd**************************@posting.google.c om...
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

Nov 12 '05 #3

P: n/a
Thank You very much for responding to my Query. I frae that the the way
that I posted my question that it may have left you with the impression
that I actually knew what I was doing. I have been creating a database
and so far it has been working very well if I do say so myself, more by
good luck then by good planing. But I am still a novice. If you could
expand on your answer and "keep the dots close together" I should be
able to follow along.
Thank you very much,
Stewart


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #4

P: n/a
Thank You very much for responding to my Query. I fear that the the way
that I posted my question that it may have left you with the impression
that I actually knew what I was doing. I have been creating a database
and so far it has been working very well if I do say so myself, more by
good luck then by good planing. But I am still a novice. If you could
expand on your answer and "keep the dots close together" I should be
able to follow along.
Thank you very much,
Stewart


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.