Linking to Access within Excel ?

[Dbennett4995]

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.

 

[Trevor G]

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

 

[Dbennett4995]

Thanks for the help. You definitely led me in the right direction.