Input new data to table against old data

steallan

Active Member
Joined
Oct 20, 2004
Messages
304
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.

:rolleyes:
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,218
Office Version
  1. 365
Platform
  1. Windows
steallan said:
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.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,218
Office Version
  1. 365
Platform
  1. Windows
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

Active Member
Joined
Oct 20, 2004
Messages
304

ADVERTISEMENT

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

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,218
Office Version
  1. 365
Platform
  1. Windows
No

What problems are you having?

Can you post the SQL you are trying?
 

steallan

Active Member
Joined
Oct 20, 2004
Messages
304
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,509
Messages
5,596,568
Members
414,079
Latest member
Frills

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top