link excel cell to SQL database
I am trying to link a cell to our SQL databases.
For example A1 enter client number 88558, I then want it to show in B1 the
client name from the SQL database.
How is this easiest achevied?
Excel is 2003, SQL is 2000.
Thanks Simon
|