Good GUI query builder

Hi:

I'm looking for a GUI query builder for a non-technical person who is
fluent in excel. I'm thinking like pivot tables in excel. Anyone know
of any?

Thanks!

Mike

On Wed, 9 Jan 2008 11:35:21 -0800 (PST), Miked
<mike.dershowitz@gmail.com> wrote:

>Hi:
>
>I'm looking for a GUI query builder for a non-technical person who is
>fluent in excel. I'm thinking like pivot tables in excel. Anyone know
>of any?

Hard to beat Excel in that respect ;)
Pivot tables are quite rare, except in real datawarehouse
/ Bvusiness Intelligence solutions, but those are usually
quite expensive.

I never tried myself, but MySQL + ODBCdriver + suitable
DSN definitions + MS Query + MS Excel should do the job.

Sounds difficult, and the first time it may take several
hours to set up and get used to, but at the end it is a
simple solution.

MS Query might be bundled with MS Excel, I'm not sure.

>Thanks!
>
>Mike

HTH
--
( Kees
)
c[_] Flirt: A woman who thinks it's every man for herself. (#411)

I use MySQL as backend, and MS Access as front end.
A winning combination.

:P

Bre-x

Hi, you can try to use SQLeonardo...


"Bre-x" <cholotron@hotmail.com> ha scritto nel messaggio
news:bf6d2b09-82b6-4f7e-8647-393657dfa784@e6g2000prf.googlegroups.com...
>I use MySQL as backend, and MS Access as front end.
> A winning combination.
>
> :P
>
> Bre-x
>