Too easy with Witango. You can create an Excel datasource and use Witango to read the file, then loop through the array and write it to your database of choice.
There is one little trick to creating the Excel datasource: you must first create a named cell range. 1) In Excel, highlight the range that begins (hopefully) with the column names at the top of your "table." Highlight the entire table. Then go to the spot near the top-left corner of Excel where it will currently display some cell location name. If your table begins in the top-left corner of the spreadsheet, that box will currently say "A1." 2) Re-name that box, and call it what you like. Call it "apples." You now have a named data range in that spreadsheet. 3) Close the Excel spreadsheet, and create your datasource. Call it what you like. 4) Now go into the Witango editor and look for the datasource. When you find it, open up the datasource, and it will appear to have a table, called apples. 5) Proceed as normal to read that data out of there. Cheers, Ian -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jose Kuhn Sent: Thursday, September 05, 2002 11:52 AM To: Multiple recipients of list witango-talk Subject: Witango-Talk: EXCEL spreadsheets II On my end I need to take an existing Excel Spread Sheet and read it into a database. What is the best way to do this!!!! Jose ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
