Thanks Thomas, good idea.  I will use LocalFS to list all the files in my directory.

All I need, is a way to change the DSN parameters on the fly to point to the needed Excel file.  I don't want to create 100 DSN!!!  That's why I wonder if Zope can use File DSN instead of Sytem or User DSN.

Maybe there would be a way to import my Excel sheets without ODBC?  I need them the way they are, not in CSV  format or anything...

But again, thanks for the tip!

-----Message d'origine-----
De : Thomas B. Passin [mailto:tpassin@mitretek.org]
Envoyé : lundi 14 mai 2001 11:45
À : zope@zope.org
Objet : Re: [Zope] ODBC DSN file

[Menard.Jean-Francois@hydro.qc.ca>]

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.

[Tom]
If you always know where the files are located, you could use the LocalFS
product.  Or you could write a simple python external method.

Cheers,

Tom P

_______________________________________________
Zope maillist  -  Zope@zope.org
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists -
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )