look-up

  • Thread starter Thread starter Pam
  • Start date Start date
P

Pam

If I have information on our server, can I type a value in
an excel spreadsheet, and in another cell have excel look
at this value and find it in a database on our server and
bring me the information.
example: In a database on our server I have in one column
employee numbers and another column their names. In
excel, if in column A1, I type in an employee number, in
cell B1, can I type a formula that will look at the
database on our server, find the employee number and bring
me back the name? Thanks, I really need this if possible.
 
Why don't you use the query, data>new database query, select the type of
database,
select brows and find it on the network, select the import type last name,
first name employee ID, DOB etc.
Save the query or import it right away. In the query wizard click next after
selecting the fields,
select employee id, from the dropdown select equals (if you are looking for
one person),
in the other dropdown either select or type the ID number, click next.
Select return data to
Microsoft Excel, click finish and select where you want it, click OK.
 
If you have an older version of Excel you may have the now depreciated
ODBC Add-in. It includes functions such as SQLOpen, SQLClose,
SQLExecQuery and SQLRetrieve.
 
Back
Top