View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nodak Nodak is offline
external usenet poster
 
Posts: 8
Default Can Paramaters be used w/ OLE SQL Query & Excel

I have used Parameters w/ ODBC MS Query, but would like to use Parameters
with an OLE connection to SQL Server... does not seems to work gives error
"No Value Given for one or More Parameters"

Ideally it would be great to refer to a Excel Range name in the OLE Query to
get the Paramaters.

Thanks in Advance