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 )