RE: Using SQLREQUEST in Excel to get AS/400 data

["MCPARTLAND, Stan" <stanley.mcpartland@xxxxxxxxxx>]

Marshall,

I don't recall your select statement, so I am assuming that each row in the
worksheet is just another row or grouping of rows from the same table.  The
best way to improve performance would be to return all 100 rows in a single
select statement.  However, this will prevent you from using SQL.REQUEST in
the worksheet cells.

If you know VBA and ADO, you should be able to use ADO to load your result
set to an array and then use VB code to load your worksheet rows.  I have
not experimented with this, so I cannot offer any advice or details.

You can also use MSQuery (Data --> Get external data --> New database query)
to place the result set directly into a worksheet.  Once the data is in a
worksheet you can use VBA to merge it with data in other worksheets if
necessary.  This works best if your select statement has static selection
criteria, but you can bring in more data than you need and use VBA to
dynamically process the data you want.

Regards,
Stan


-----Original Message-----
From: Marshall Akins [mailto:makins@hannasteel.com]
Sent: Friday, 31 August, 2001 11:57 AM
To: midrange-l@midrange.com
Subject: RE: Using SQLREQUEST in Excel to get AS/400 data



Thanks, it works.  Now, any tips on how to make it faster?   I used
SQLREQUEST in 100 rows, doing a simple statement and it took about 2
minutes to calculate all of the rows.