ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   link excel cell to SQL database (https://www.excelbanter.com/excel-discussion-misc-queries/136385-link-excel-cell-sql-database.html)

strippier

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




All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com