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