[Zope] ODBC DSN file

[Tino Wildenhain]

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=20
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=E7ois M=E9nard
> 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 =E9tage
>               Montr=E9al, Qu=E9. H2L 4P5