Linking to Access within Excel ?

Dbennett4995

New Member
Joined
Dec 1, 2009
Messages
2
What I am wanting is for when specific data is entered into Excel, lets say
'A-1', then I would want that data to be matched against an Access table which would then pull the aligning data and place it in 'B-1'. My situation is that I am importing products into our company's website. We already have a industry-wide database which has each manufacturer's products, model numbers, image names, etc. When filling up my excel import product sheet I would want the model number that I paste into Column 'A' automatically reciprocate the specific name call for that product's image. So as an example:
Model size image
A B C
1 kSS80 kSS080.jpg
input output
my spaces weren't taking above in my example. Column A , row 1 would be the model being input and the output would be displayed in column B in the row equivalent to the data being input.

How could I accomplish this? Any advice is greatly appreciated.
 
Last edited:

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,701
Office Version
  1. 2016
Platform
  1. Windows
Welcome to the forum.

In access you have the option to link excel direct into tables in access. So changes that are made are automatically updated. depending on the verison of Office you use depends on the link feature. If 2003 then use the file menu and get external data then look for link then select your excel spreadsheet to link. If 2007 then select the External Tab and then on the left look at your import options.

Hope this helps

Trevor G
 

Watch MrExcel Video

Forum statistics

Threads
1,123,259
Messages
5,600,574
Members
414,390
Latest member
plimbu

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