ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Newbe looking for info on dymaic queries in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/127120-newbe-looking-info-dymaic-queries-excel.html)

Sean Cooper

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,


All times are GMT +1. The time now is 08:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com