You can create a DSN Less connection to any type of ODBC driver, but
unfortunately you cannot do this in wtiango. You can do this in
VB, .NET, or RealBasic.
You may be able to also find a com object to read in excel files, or
convert them to CSV or something.
If you find the COM, don't get too excited, with witango, you can get
some coms to work, and some just don't.
I don't know your programming abilities, but if it were me, I would
write a command line utility in VB 6, or RealBasic, that takes an
environment variable passed from witango external action, the env var
could pass the path to the excel file, and then in the CL app, you
create a DSN Less connection to the excel file, extract the data, and
pass back to witango in a format it could understand.
There may be other ways to skin this, but that is what comes to mind.
I can confirm I have created DSN Less connections to MS Access, and
SQL, and I am sure it would work with a excel driver, you would just
have to search around the net for syntax.
Some notes from the top of my head:
You have to use the ADODB objects to do this, and it is the
connection string that is the important part. You can basically
specify everything you would when you create a DSN in the ODBC driver
manager, inside the connection string, so you don't need to create a
DSN first, thus a DSN-Less connection.
Here is some code from an app where I make a DSN-Less connection to
ms access db:
connstring = "Driver={Microsoft Access Driver
(*.mdb)};Dbq="+f.absolutePath+";Uid=admin;Pwd="
Where f.absolutepath is the absolutePath of the access db I want to
open, which can be passed in, so I can open ANY, ANYWHERE with this app.
A connection string that requires a DSN setup in ODBC manager would
look something like this (from memory):
connstring = "DSN=myDsn;Uid=myUserID;Pwd=myPassword"
I hope that all helps, you sound like you REALLY need a solution.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
On Jun 22, 2005, at 7:01 AM, Scott Cadillac wrote:
Hi Stephen,
Witango can read Excel files via an ODBC connection, just like a
database.
So either your files just have to conform to an existing ODBC
configuration,
or you need to create ODBC connections dynamically with each file
(a 3rd
party tool?).
Hope that helps.
~ Scott Cadillac
~ 403-254-5002
~ [EMAIL PROTECTED]
~ Custom Software for Business
http://custom.softwarefor.net
~ The XML-Extranet Partnership
~ P.O. Box 69006
RPO Bridlewood SW
Calgary, Alberta
Canada T2Y 4T9
-----Original Message-----
From: Stephen Su [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 22, 2005 6:04 AM
To: [email protected]
Subject: Witango-Talk: Witango and EXCEL
Can someone please help us. We've been trying to access EXCEL data
from Witango. The idea is that people can upload EXCEL files via.
witango TAF file or standard FTP and then Witango would access that
file to read the data and use it to load our actual database.
We have
not been able to successfully do this at all. Is EXCEL access from
Witango an urban legend?
Please help, anyone. Especially if you have sample TAF / EXCEL files
for us to test and setup on our servers as well.
Thanks a bunch.
Best,
Stephen
______________________________________________________________
__________
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
