Hi Gene, Not that I understand 100% of what you're doing, but I think you're saying each Excel file has a different ODBC connection, right?
If you have an array that describes all your Excel file connections, then you can do a Loop on that and use Variables for your datasource connections - then you only need one Search Action and one set of code (for parsing the data) for the whole thing. See http://xmlx.ca/articles/571.aspx Hope this helps. Cheers.... Scott Cadillac, 403-281-6090 ~ [EMAIL PROTECTED] ------------ XML-Extranet ~ http://xmlx.ca ~ http://forums.xmlx.ca Well-formed Programming in C# .NET, Witango, MSIE and XML ------------ IExtranet ~ http://iextranet.ca Witango ~ http://witango.org EasyXSLT ~ http://easyxslt.ca IIS Watcher ~ http://iiswatcher.ca ------------ ________________________________ From: Wolf, Gene [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 11:46 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: Something completely different OK, this may be way off the wall but I figured one of you folks would have tried this, or know it can't be done. I have a number of excel spreadsheets that I will be reading data from using Witango. There are about 14 of these sheets and I have working ODBC links to each one of these. Now, the format of all of these sheets is exactly the same and I need to be able to create the exact same reports from each of these spreadsheets. Is there any way I can change the table I'm looking at in either a search action or a direct DBMS so I can loop through a list of table names and create the reports without duplicating the code for every table? Does this make sense to anyone? *laughs* Gene Wolf Business Systems Analyst, TLMN DRS Optronics, Inc. 2330 Commerce Park Drive Palm Bay, Florida 32905 Phone: 321-309-0685 E-mail: [EMAIL PROTECTED] ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
