| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Query SQL Data in Excel with a function?
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 -- FullCity Consulting Inc. Certified FileMaker Developer Platinum FileMaker Business Alliance Members 2007 FileMaker Partner of The Year |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SQL & Like Query function in excel | Excel Worksheet Functions | |||
| Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
| external data function error-MS Query | Excel Worksheet Functions | |||
| Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
| Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
Threaded Mode
