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.
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.