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