Hi John,
Using Excel as a DSN is painfully slow! It's beter to import it into Access. Also, if you just have an Excel Worksheet, you won't be able to see the columns and tables through the ODBC. It has to be a Workbook. Rick Sanders > > -----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 ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
