Thanks for your response!

Yes, I could do that, but I would like to skip this step if possible, cause I will keep receiving data form Excel sheets for a while. 

What I would like to do is create a web interface to let users put the exel files in a directory on the server, import the data themselves, create some transfer directives, end export the result.

So, would it be possible?

-----Message d'origine-----
De : Tino Wildenhain [mailto:tino@wildenhain.de]
Envoyé : lundi 14 mai 2001 11:22
À : Menard.Jean-Francois@hydro.qc.ca; zope@zope.org
Objet : Re: [Zope] ODBC DSN file

Hi Jean-Francois,

I would import the Excel-Sheets into an RDBMS first
and then use this to access your data.

Regards
Tino Wildenhain

--On Montag, 14. Mai 2001 11:09 -0400 Menard.Jean-Francois@hydro.qc.ca
wrote:

>
>         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çois Ménard
> 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 étage
>               Montréal, Qué. H2L 4P5