Importing Fields

T

Tony

Does anyone know if it is possible and how to just add one field to a record
when importing from an excel file instead of importing the whole reocrd?
Example, we have a contact database and everyone needs to have an e-mail
address I want to know if i can just import that field into specific
records. Thanks for any responses in advance.
 
K

KARL DEWEY

What you want to do is to update a field.
First you need to add the field to your table.
Next figure which field in the Excel correlates to a field in the table -
Last_Name, Firat_Name, Initial, etc. These fields along with the e-mail
field will need to be imported otherwise you can not get the data aligned
correctly.
Create an update query using the imported data table and your contact table.
Join the two tables in the query on the correlation fields.
 
D

David Lloyd

Tony:

One possibility would be to link the Excel worksheet into Access. You could
add an email field to your existing Access table. You could then write an
UPDATE query (joining the linked worksheet with the Access table) to pull
the email field into the Access table. This assumes that your Excel
worksheet has enough information to uniquely match up the records with the
Access table.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Does anyone know if it is possible and how to just add one field to a record
when importing from an excel file instead of importing the whole reocrd?
Example, we have a contact database and everyone needs to have an e-mail
address I want to know if i can just import that field into specific
records. Thanks for any responses in advance.
 
Top