Importing data (2000)

Topic

New Reply

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

Reply | Quote

Replies

Click File | Get Extrenal Data | Import…

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

Click File | Get Extrenal Data | Import…

Reply | Quote