Hi Jose, If you have MS Office installed, then use the Excel ODBC Driver to read Excel like normal database tables.
Note: I don't recommend trying to Insert or Update an Excel datasource. It's not really designed for it and often fails, but reading (Search Actions and SELECT statements) seams okay, even for large files. Hope this helps. Cheers.... Scott Cadillac http://xml-extra.net [EMAIL PROTECTED] http://witango.org [EMAIL PROTECTED] VP, Research and Development Plus International Corp. 403-281-6090 [EMAIL PROTECTED] http://www.plusinternational.com Vancouver, BC, Canada Does your company have an Enterprise Information Portal? Check out Salsa at www.plusinternational.com/flash/salsa.htm ----- Original Message ----- From: "Jose Kuhn" <[EMAIL PROTECTED]> To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> Sent: Thursday, September 05, 2002 12:51 PM 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
