Re: Query/SQL/Excel

Hello Guy

<verndor response>
If you are interested in pushing the data from the iSeries, rather than trying to pull it from the PC, you might like to look at our RPG2SQL Integrator product - it contains an Excel-specific component that works directly with spreadsheets, not through SQL. It uses standard procedure calls to do the work from your RPGLE programs.

You can look at our site at www.rjssoftware.com or email me here or at vern@xxxxxxxxxxxxxxx or contact sales@xxxxxxxxxxxxxxx - I can even say that in a couple months there should be a command to export data directly to Excel spreadsheets, using the functions of the product.
</verndor response>

Regards
Vern

At 07:23 AM 7/3/2007, you wrote:

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

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.