| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using SQLRequest with Excel 2003
BTW - function is now returning #N/A error
"Larry Gomez" wrote: Has anyone succeeded in using this function with Excel 2003? Have a worksheet that woked fine in Excel with Office 2000. Was recently upgraded to Office 2003 and this function no longer works. No other changes were made to the worksheet. Am now running Office 2003 on WinXP Prof v-2002 sp-2. Have read other threads on this site back to 2005 that discuss downloading xlodbc.exe. Have downloaded this file and extracted all the files to c:\documents and settings\user\application data\microsoft\addins. The ODBC addin shows as available from within Excel. The ODBC connection referenced in the formula exists and is working. Syntax for the formual is : =SQL.REQUEST("DSN=DSS Database;UID=#01BOB;PWD=user;Database=PRD_DSS00DP0 _DB",,,"SELECT dbo.customer2.customer_number FROM dbo.customer2 WHERE dbo.customer2.office_id = '" & J4 & "'",FALSE ) What have I missed? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL 2007 IS RUNNING, DIDN'T REQUEST IT, HOW TO GET RID OF IT | Excel Discussion (Misc queries) | |||
| Excel 2007: request for help | Excel Worksheet Functions | |||
| SQL.REQUEST not working in EXCEL 2003 | Excel Worksheet Functions | |||
| Access to Excel using SQL.REQUEST | Excel Discussion (Misc queries) | |||
| Does SQL.REQUEST work in Excel X? | Excel Discussion (Misc queries) | |||
Threaded Mode
