Re: Query/SQL/Excel

["Angus MacQueen" <amacqueen@xxxxxxxxx>]

Not sure if this will help Guy but you could create the alias on the iSeries
then use ODBC  from Excel to access the alias.

Angus - also from a rainy UK

On 03/07/07, Guy Terry <guy.terry@xxxxxxxxxxxxxxxxxxx> 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.