Posted to microsoft.public.excel.programming

external usenet poster

Posts: 8

ms query - from statement

We have numerous queries that we would like to run against AS400's at
different locations. The problem is each AS400 has a different machine id.
When a ms query is created in Excel it records this in the FROM statement in
the SQL. Is there any way to get around this? We know how to change the
SQL, but want to be able to prompt for the AS400 name or at least enter it
into a cell on the worksheet. Is this possible?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IF Statement Query	MissV	Excel Worksheet Functions	5	May 27th 08 09:42 AM
If statement query	Rajula	Excel Worksheet Functions	3	April 20th 07 11:14 AM
IF statement query	shakey1181	Excel Discussion (Misc queries)	2	November 8th 06 03:17 PM
IF statement query	JaB	Excel Worksheet Functions	5	September 27th 06 04:34 PM
Use MS Query in VBA to only get a SQL statement	RB Smissaert	Excel Programming	6	May 23rd 05 06:33 PM

All times are GMT +1. The time now is 02:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us