Import specific data from excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have imported an excel sheet of addresses/contacts into an Access database.
I want to add the data to an existing table that has many more fields than
the imported file. I only want to import the address information. I can't
seem to find an answer. Thanks!
 
Thank you. I tried both. The append query will add hundreds of identical
entries for each contact and the update query will not allow me to specify to
which field to update. I'm obviously missing something here.

Alexis
 
It sounds like you need to use an update query. It is just that you are not
doing it correctly.
In design view of the query builder, you need to add both tables and join
them on some common field. The put the fields of the table you want to
update in the query fields. The select the query type as Update. Now in the
Update To row for each field, type in the name of the field from the imported
table.
 
Dave, thanks for your patience. I can see how this works now due to your
help. However, I still have a question. You say to join the tables on a
common field. I don't have ac ommon field that I know of. In the table I am
importing from, I only have names, addresses and telephone numbers. Should I
add some nonsenical field to both tables in order to import which I can later
delete such as an update date or something? Thanks again,. Alexis
 
Adding a field wont help. The idea is to be able to determine which record
updates which record in the other table. How about the name? would it be the
same in both tables?
 
Hi -

You can use an append query, with only the table of imported data in it. In
the "append to" of the query, select the table you want to append the data to.
You don't need to append all the fields from the source table if some are not
required, and you don't need to put data in all the fields in the destination
table. Map the source fields to the destinations fields using the "appen to"
box in the query grid.

Having said that, if your destination table has required fields that are not
in the source data, you will have to modify the append query.

Hope this helps

John
 
Back
Top