View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sean Cooper Sean Cooper is offline
external usenet poster
 
Posts: 3
Default Newbe looking for info on dymaic queries in Excel

Hello,

I have been able to setup the ODBC, use the query editor and get the info in
a worksheet.

Now, I want I want to setup a column, row, or area in my worksheet and use
this data in my query. It look like

12345 | 54321 | 000001 ( this list can get long)

and use it like:

Select emp_name, emp_id from emp where emp_id in ( 12345, 54321, 00001);

Can someone point me in a direction?

Thanks in advance,