importing data

  • Thread starter Thread starter Student Databaser
  • Start date Start date
S

Student Databaser

I have taken out (copied and pasted) a random sample of addresses from a
table in my DB to an excel spreadsheet. I have been working on updating
these addresses and now i would like to be able to paste them back into my DB
and have them automatically update the old addresses. Each address has a ID
number that is the Primary key.

How should i go about doing this?
 
Hi,

The following should work. Import the excel data back into a new table.
Then, create an update query to update the data in your original table to the
data in your new table when the ID numbers match.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

primary key - concatenated or autonumber? 6
Update primary Key. 1
Need Help Please 5
Importing data 3
Appending last entry Access 2000 2
Access Automatically Send a notification email once a record is added 0
importing dilemma 1
A2003 bringing in data from an Excel spreadsheet 1

Back
Top