RE: Query/SQL/Excel

SEQUEL from Help Systems. The benefit is that it runs natively, without the
exposure and performance issues of ODBC.

Paul Nelson
Cell 708-670-6978
Office 708-425-4198
nelsonp@xxxxxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Guy Terry
Sent: Tuesday, July 03, 2007 7:24 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Query/SQL/Excel

Greetings from a rainy UK.



This is a question about getting data off the iSeries and into Excel.



I've never used Query/400, but I have been shown how to use Microsoft Query
to get data (via ODBC Connection) from our iSeries 'Tables' into Excel. And
then today I had some brief instruction in writing SQL SELECT statements to
achieve the same result.



The problem is I was using MS Query to write the SQL, and found it's not
especially suited for that task (e.g. it doesn't support Aliases). I then
found, in iSeries Navigator, the 'Run an SQL Script' option. Which is great
at writing SQL, but I can't then get my data into Excel.



So the question is what SQL 'editor' can I use to sit between an ODBC
connection to the iSeries and Excel? I realise this is not necessarily an
iSeries specific question, but I can't be the only person here who wants to
do this,



Guy