Using Excel to query the database

Using Excel to query the database

am 15.08.2011 23:33:35 von Rob Tanner

--_004_CA6EDEBEE94Drtannerlinfieldedu_
Content-Type: multipart/alternative;
boundary="_000_CA6EDEBEE94Drtannerlinfieldedu_"

--_000_CA6EDEBEE94Drtannerlinfieldedu_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Hi,

I have a fairly standard set of queries that I do then I save the resultset=
as a CSV and send it off to a couple dozen folks. My understanding is tha=
t I can build an Excel .iqy file that can do the queries (one for each quer=
y) and that I need send that file but once to the users. Does anyone have =
any sample Excel .iqy files for MySQL access that they would be willing to =
share (with passwords removed, of course)?

Thanks.


Rob Tanner
UNIX Services Manager
Linfield College, McMinnville Oregon

ITS will never ask you for your password. Please don=92t share yours with =
anyone!

[cid:74641041-0AC7-459B-AA5C-2BDE34206F14]

--_000_CA6EDEBEE94Drtannerlinfieldedu_
Content-Type: text/html; charset="Windows-1252"
Content-ID: <8D4E92FA6252F845AFEA13F93499F6A7@linfield.edu>
Content-Transfer-Encoding: quoted-printable



252">

e-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-fami=
ly: Calibri, sans-serif; ">

Hi,




I have a fairly standard set of queries that I do then I save the resu=
ltset as a CSV and send it off to a couple dozen folks.  My understand=
ing is that I can build an Excel .iqy file that can do the queries (one for=
each query) and that I need send that
file but once to the users.  Does anyone have any sample Excel .iqy f=
iles for MySQL access that they would be willing to share (with passwords r=
emoved, of course)?





Thanks.

t">



Rob Tanner

UNIX Services Manager

Linfield College, McMinnville Oregon



plate,Times New Roman">ITS will never ask=
you for your password.  Please don=92t share yours with anyone!

al">





--_000_CA6EDEBEE94Drtannerlinfieldedu_--

--_004_CA6EDEBEE94Drtannerlinfieldedu_--