[Zope] ODBC DSN file
Mon, 14 May 2001 17:22:12 +0200
I would import the Excel-Sheets into an RDBMS first
and then use this to access your data.
--On Montag, 14. Mai 2001 11:09 -0400 Menard.Jean-Francois@hydro.qc.ca=20
> 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.
> - Is it possible to connect to a File DSN ODBC from Zope?
> - Is there a better, cleaner solution I could try?
> Jean-Fran=E7ois M=E9nard
> Intranet DPAS
> Pratiques d'affaires et orientations
> * (514) 840-3000 poste 3939
> * (514) 840-5585
> * firstname.lastname@example.org
> * 855 Ste-Catherine est, 6e =E9tage
> Montr=E9al, Qu=E9. H2L 4P5