Input new data to table against old data

[steallan]

Hi
I think this must be easy to do but not sure how. I've got a table with a unquie number in one column and an empty column. Can i import data into the empty column so values are matched against the unique number?

What i mean is ive got a spreadsheet with the data for the empty column in it along with the same unique numbers in the other column. so when i import the data into the table from this spreadsheet i want the value next to a unique number to be placed next to the same unque number in the access table.

God knows if that makes any sence.

If anyone is god and understands and can help that would be great. A none code way of doing this would be good to. I think its an update query or something.

Maybe i have to import the data into its own tabel then use an update query.

 

[Norie]

Maybe i have to import the data into its own tabel then use an update query

That would be one way of doing it.

But you could just create a link to the spreadsheet.

If the data in the spreadsheet is organised correctly then Access will treat it as a table and you can use it in queries etc.

 

[steallan]

Thx
But how do you use the update query to update the data?

 

[Norie]

Just link the two tables using the unique ID.

Then chose the fields you want to update from the original table ie. the field that is empty.

Then put the field from the other table in Update to.

 

[steallan]

I've been trying to do that. Dose it matter that the updated field isn't empty?

 

[Norie]

No

What problems are you having?

Can you post the SQL you are trying?

 

[steallan]

It wont update the bloody thing!
This is driving me mad and now ive found there is duplicate values in a field that shouldn't have them. KILL ME

Ok thx for the help but now ive got to got sort out the duplicate value problem

thx