×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
midrange.com
