Re: Query/SQL/Excel

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

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.