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

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • S. Graefner
    #1

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

    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
    Tags: None
    • Steve Jorgensen
      #2
      Re: Download/Importing a single Access record from a removeable data media ie 3.5" disk or USB drive

      On 29 Feb 2004 16:09:24 -0800, sgraefner@hfx.e astlink.ca (S. Graefner) wrote:
      [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[/color]

      I recommend using DoCmd.TransferS preasheet 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.

        Comment

        • paii, Ron
          #3
          Re: Download/Importing a single Access record from a removeable data media ie 3.5" disk or USB drive

          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" <sgraefner@hfx. eastlink.ca> wrote in message
          news:fd0400f8.0 402291609.3510d f5f@posting.goo gle.com...[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[/color]


            Comment

            • Stewart Graefner
              #4
              Re: Download/Importing a single Access record from a removeable data media ie 3.5&quot; disk or USB drive

              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!

                Comment

                • Stewart Graefner
                  #5
                  Re: Download/Importing a single Access record from a removeable data media ie 3.5&quot; disk or USB drive

                  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!

                    Comment

                    Previous template Next
                    Working...