×
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.
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
