Using SQLRequest with Excel 2003
 

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?

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?