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