I found that I can pass the filename of the Excel file I want in the connection string with the DBQ parameter.

How could I pass this parameter in the Z ODBC connection string?  Have I to modify the Zope source code?  If so, wich file?

 -----Message d'origine-----
De : Menard.Jean-Francois@hydro.qc.ca [mailto:Menard.Jean-Francois@hydro.qc.ca]
Envoyé : lundi 14 mai 2001 12:03
À : tpassin@mitretek.org; zope@zope.org
Objet : RE: [Zope] ODBC DSN file

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 )