| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Query - From in SQL
Question...
We have quite a few queries developed in Excel/MS Query that query an AS400. We need to share these with users at other locations that use an AS400 with a different name. Is there any way around changing the SQL FROM statement for the AS400 machine name to another AS400 machine name without editing the query in MS Query and doing it in View, SQL? Looking for the quick, easy way to do this, because there are too many to change this way. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
| Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
| Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| Edit Query from Excel will not open query in MSQuery | Excel Programming | |||
Threaded Mode
