Using Excel to query the database

--_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 [at] linfield.edu>
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DWindows-1=
252">
</head>
<body style=3D"word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-lin=
e-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-fami=
ly: Calibri, sans-serif; ">
<div>Hi,</div>
<div><br>
</div>
<div>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)?</div>
<div>
<div><br>
</div>
<div>Thanks.</div>
<font face=3D"Calibri,Verdana,Helvetica,Arial"><span style=3D"font-size:11p=
t"><b><br>
<br>
Rob Tanner<br>
</b>UNIX Services Manager<br>
Linfield College, McMinnville Oregon<br>
<br>
</span></font><font color=3D"#7B0000"><font size=3D"2"><font face=3D"Copper=
plate,Times New Roman"><span style=3D"font-size:10pt"><b>ITS will never ask=
you for your password.  Please don=92t share yours with anyone!<br>
</b></span></font></font></font><font face=3D"Calibri,Verdana,Helvetica,Ari=
al"><span style=3D"font-size:11pt"><br>
<img src=3D"cid:74641041-0AC7-459B-AA5C-2BDE34206F14"></span></font></div>
</body>
</html>

--_000_CA6EDEBEE94Drtannerlinfieldedu_--

--_004_CA6EDEBEE94Drtannerlinfieldedu_--
Rob Tanner [ Mo, 15 August 2011 23:33 ] [ ID #2063322 ]
Datenbanken » gmane.comp.db.mysql.general » Using Excel to query the database

Vorheriges Thema: build mysql 5.5.15 err
Nächstes Thema: hand replication