[Zope] ODBC DSN file
Menard.Jean-Francois@hydro.qc.ca
Menard.Jean-Francois@hydro.qc.ca
Mon, 14 May 2001 11:09:33 -0400
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C0DC87.E1DFF360
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I need to transform a lot of data from multiple Excel files and
export one standard big text file.
I created an ODBC System DSN, and it work fine. But I have about
100 excel files, and I would like to develop an interface with a =
dropdown
list with all the excel files in my directory, choose one, and import =
it.
Any ideas how I could do that? I tried to create a File DSN, but
Zope doesn't seem to detect it. With such a connection, I could change =
the
connection string into the DSN file when needed.
So:
- Is it possible to connect to a File DSN ODBC from Zope?
- Is there a better, cleaner solution I could try?
Thanks!
Jean-Fran=E7ois M=E9nard
Intranet DPAS
Pratiques d'affaires et orientations
* (514) 840-3000 poste 3939
* (514) 840-5585
* menard.jean-francois@hydro.qc.ca
* 855 Ste-Catherine est, 6e =E9tage
Montr=E9al, Qu=E9. H2L 4P5
------_=_NextPart_001_01C0DC87.E1DFF360
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>ODBC DSN file</TITLE>
</HEAD>
<BODY>
<P> <FONT SIZE=3D2>I need to =
transform a lot of data from multiple Excel files and export one =
standard big text file.</FONT>
</P>
<P> <FONT SIZE=3D2>I created =
an ODBC System DSN, and it work fine. But I have about 100 excel =
files, and I would like to develop an interface with a dropdown list =
with all the excel files in my directory, choose one, and import =
it.</FONT></P>
<P> <FONT SIZE=3D2>Any ideas =
how I could do that? I tried to create a File DSN, but Zope =
doesn't seem to detect it. With such a connection, I could change the =
connection string into the DSN file when needed.</FONT></P>
<P> <FONT SIZE=3D2>So:</FONT>
</P>
<P> <FONT SIZE=3D2>- Is it =
possible to connect to a File DSN ODBC from Zope?</FONT>
</P>
<P> <FONT SIZE=3D2>- Is there =
a better, cleaner solution I could try?</FONT>
</P>
<P><FONT SIZE=3D2>Thanks!</FONT>
</P>
<P><FONT SIZE=3D2>Jean-Fran=E7ois M=E9nard</FONT>
<BR><FONT SIZE=3D2>Intranet DPAS</FONT>
<BR><FONT SIZE=3D2>Pratiques d'affaires et orientations</FONT>
<BR><FONT SIZE=3D2>* (514) =
840-3000 poste 3939</FONT>
<BR><FONT SIZE=3D2>* (514) 840-5585</FONT>
<BR><FONT SIZE=3D2>* menard.jean-francois@hydro.qc.ca</FONT>
<BR><FONT SIZE=3D2>* =
855 Ste-Catherine est, 6e =E9tage</FONT>
<BR><FONT =
SIZE=3D2> &nb=
sp; Montr=E9al, Qu=E9. H2L 4P5</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C0DC87.E1DFF360--