Help updating database from spreadsheet

[KelvClark]

Hi,

I have a spreadsheet that has 1 column I would like to use to update one column in my database. I have a column on both the database and spreadsheet that would link them together. I’m wondering what the syntax would be to do this.

Column 1 is the reference to link them together, but how do I go about overwriting Database column 2 with Spreadsheet Column2?

What would the code be and where do I enter it?



Database: Column1 = 1,2,3,4,5,6,7,8,9
Column2 = xd,fr,hy,fd,er,ty,bg,nh,er

Spreadsheet: Column1 = 1,2,3,4,5,6,7,8,9
Column2 = aa,bb,cc,dd,ee,ff,gg,hh,ii

Thanks in advance guys, I’m new to Access

[June7]

I am confused. If column 1 in each dataset is the 'link', why would you want to update column 2 with value from column 1? Did you mean update table column 2 with spreadsheet column 2?

[KelvClark]

Hi,

Yeah sorry, I want to overwrite Database column 2 with Spreadsheet Column2.
I probably should have mentioned that i intended the commas to represent separate rows in each column.
Thanks

[June7]

Can you set a link to the spreadsheet?

If so, build a query with query designer that joins the datasets then switch it to UPDATE query type. Under table column 2 on UPDATE TO row use criteria:

spreadsheet!column2

Use your actual object and field names.