Return info from database based on column of data in excel

[Steve Graham]

Hi

If I have a column of index numbers in excel, is it possible to query
a database for each index number and return the related data from a
database?

Example: I have the following column data in excel

Index
101
102
103
104
105

I want to query a database table that contains, say, the titles of the
index numbers and put the results in the cell next to the index
number, but I want to do this for every row that has an entry. The
results should be

Index
101 Title of 101
102 Title od 102
103 Title of 103
104 Title of 104
105 Title of 105

I can see how to do this for one cell using get external data, but I
cannot find a way of doing for every row with an index number.

Is it possible? Can anyone point me towards some information or give
me an overview of how to do it?

Thanks

Steve Graham

 

[Guest]

I face a similar situation to Steve's; I would like to pass values in a column to a query so that values from the database, when values exist, would populate adjoining cells in the row

Thanks, Eric

----- Steve Graham wrote: ----

H

If I have a column of index numbers in excel, is it possible to quer
a database for each index number and return the related data from
database

Example: I have the following column data in exce

Inde
10
10
10
10
10

I want to query a database table that contains, say, the titles of th
index numbers and put the results in the cell next to the inde
number, but I want to do this for every row that has an entry. Th
results should b

Inde
101 Title of 10
102 Title od 10
103 Title of 10
104 Title of 10
105 Title of 10

I can see how to do this for one cell using get external data, but
cannot find a way of doing for every row with an index number

Is it possible? Can anyone point me towards some information or giv
me an overview of how to do it

Thank

Steve Graham