Gene - are you wanting all the records of all the tables into one output, or do you need to keep the results separated by table?
Are your Excel filenames static or changing? > -----Original Message----- > From: Wolf, Gene [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 25, 2004 1:33 PM > To: [EMAIL PROTECTED] > Subject: RE: Witango-Talk: Something completely different > > > Scott, no, I could do that and that may be a solution. > What I have, in essence, is a single ODBC with what amounts > to multiple tables within the "database". All of the "tables" > have the exact same structure so I want to loop through all > of the records of one table, list them, then read all of the > records of the next table, list them, etc. > > This is hard to explain but I hope this gives you a better > idea of what I'm trying to do. > > Thanks for your help! > > -----Original Message----- > From: Scott Cadillac [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 25, 2004 2:19 PM > To: [EMAIL PROTECTED] > Subject: RE: Witango-Talk: Something completely different > > > 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 > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
