If you are using ms-sql, trying linking the excel file via enterprise
manager first, then build a query. From Witango, link to the query.
Hope this helps
Regards,
Len Wright
Plus International Corp
www.plusinternational.com
Direct: 604-415-2384
Fax:604-415-0830
>>> [EMAIL PROTECTED] 07/10/02 05:59AM >>>
Has anyone successfully used Excel as a data source? I have a
spreadsheet that I want to use that tracks copier, electrical, and fuel
usage at my school. It is updated by a secretary, and calculates all
kinds of things. I then want witrango to generate a dynamic web page
with the summary results each week. I could use a linked table in
Access. But I'm just wondering.
I set up the ODBC datasource pointing to the .xls file. But witango
keeps telling me it can't connect. Is there something I am missing on
the excel side?
Thanks for any pointers.
John
________________________________________________________________________
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
