Query SQL Data in Excel with a function?

[FullCity Consulting Inc.]

I have an Excel 2007 spreadsheet with a column of primary keys that match
data in a FileMaker 9 database that is accessible via ODBC (using the
DataDirect SequeLink 5.5 drivers). What I'd like is to be able to fill the
second column with live data from the FileMaker database.

I've been reading about SQLREQUEST() but I can't seem to find that function
after installing the XLODBC add-in (for Excel 2002). Also, I'm not entirely
certain that add-in will work with Excel 2003 or 2007.

Can what I am trying to do be accomplished? Any thoughts?

Thanks!
Adam Aronson

 

[chip.gorman]

I'm still working with 2003, but in that version you'd just use the
Data-Import External Data menu item to set up your query to pull the
field(s) you want for the record you want. You could record the action
of pulling the fields and then revise the code to put your own
criteria in.

It will return the record you select as a row, which you'd probably
want to store in a background sheet temporarily, and display either by
INDEX-MATCH formulas or using VBA to hard-enter it.