I hate Visual Basic
April 26, 2006 12:18 AM   Subscribe

MSExcel: how to place data in one cell from an ODBC source based on data in another cell?

Let's say I have an Excel sheet. I want to use the value in cell A1 as my SELECT criteria for querying an ODBC source, and populate cell A2 with the value of a field in the fetched row. How do I do this? Can it be done without Visual Basic (which I don't know well)?
posted by randomstriker to Computers & Internet (1 answer total)
 
Nevermind, I figured it out. Get external data, database query, using a parameter query.
posted by randomstriker at 1:06 AM on April 26, 2006


« Older To me or not to me, that is the question.   |   Is it fair for me to want to live close (walking... Newer »
This thread is closed to new comments.