How do you update existing data in a table with an import?

[rschoenb]

Hi,

I have a table that I am importing external data into via excel. I only want the data that changed to be updated such a resolution date/status/resolution fields within the database. How would I go about doing this I just can't append the data because that would cause duplicates and it wouldn't be allowed anyway due to duplicate "Keys" which is the case number.

Thanks for your help please let me know if you need any more information.

Ruth S.

[mehmetcik]

You would probably need to use a macro.

Read the new data into a new sheet

Duplicate your data sheet in the same workbook

use a formula in the new data sheet to compare the old data with the imported data

Copy paste the values in your table

Delete the imported data.

[rschoenb]

So you think I have to cut and paste data from my export file once I compare the excel sheets? Meaning I have to copy and paste to update the Access table? that could be a lot of work I was hoping I could have imported based on "Keys".

[mehmetcik]

No

I am saying import the data into your workbook as a new sheet.

Then use a macro to move your data for you.

If you paste samples of:

Original Data

Import Data

Merged Data

Threee separate sheets then someone here will show you how its done.

I can do that in a couiple of hours if no one else picks it up.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic