View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 866
Default Using values in Excel as parameters in Microsoft Query connection

I currently have an Excel sheet containing data, and I'd like to create a SQL
query where parameters in my query are fields in my Excel sheet. I know how
to create a SQL query or other data connection, but I don't know how to
include my Excel data as a datasource in the query. Is this possible, and, if
so, how would I do it?


Thanks in advance,
Dan