John, I've used the Excel ODBC driver in the past to import some data -- i.e. just a one-off. It is slow, but does the job.
Of course, you need to have the appropriate Office components installed on the server and set the Deployment path to the data to somewhere the server can see. Jon -----Original Message----- From: John Newsom [mailto:[EMAIL PROTECTED]] Sent: 10 July 2002 1:59 To: Multiple recipients of list witango-talk Subject: Witango-Talk: Excel as data source 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
