Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Nov 2002
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing data (2000)

    I would like to fill some fields on a form in one database with the data in fields from another database. For example, I have the first and last names in one database and I would like to fill the fields in another database with those names. How should I go about doing this?
    Thanks for helping

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing data (2000)

    Click File | Get Extrenal Data | Import...

  3. #3
    Star Lounger
    Join Date
    Nov 2002
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing data (2000)

    Thanks, but how do i get the fields in the form populated with the data from the imported query

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Importing data (2000)

    You will need to import or link a table from the other database (File | Get External Data | Import... or File | Get External Data | Link Tables...)
    Set the record source of the form to the name of the imported/linked table or of a query based on it. You can then set the control source of text boxes etc. on the form to the names of fields from the record source.

  5. #5
    Star Lounger
    Join Date
    Nov 2002
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing data (2000)

    The form already had a record source from the original table. The records I want to import are in addition to other records already in the database. Any other advice?
    Thanks

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Importing data (2000)

    You might be able to use DLookup, but you haven't explained how the records in the existing record source relate to the records in the imported/linked table.

  7. #7
    Star Lounger
    Join Date
    Nov 2002
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing data (2000)

    Thanks
    I am trying to import Last Name, First Name and ID No. from one existing database into another existing database that already includes a number of records.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Importing data (2000)

    So you want to append records to a table.
    - Create a query based on the imported/linked table.
    - Add the fields you need to the query grid.
    - Select Query | Append Query...
    - Select the existing table you want to add the records to, then click OK.
    - Specify 'Append To' for each field (Access may have suggested a field name already)
    - Select Query | Run and confirm that you want to add records.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •