Excel as database in win98 vs. XP

From: Mette D (MetteD_at_discussions.microsoft.com)
Date: 08/16/04 

Date: Mon, 16 Aug 2004 00:45:02 -0700

In a program I need to read an excel file and this is easy in XP treating the
excel file as a database by importing a certain package (java.sql.*) in the
program. In win98, however, this approach is little helpful since the excel
file is not recognised as a database with a driver: the ODBC driver manager
cannot find the data source name...

How can I update the database software, since I suppose this is the only
difference to this matter between XP and win98? If this is not correct, any
solutions to my problem?

Thanks!

Relevant Pages

  • Re: Excel as database in win98 vs. XP
    ... MD> In a program I need to read an excel file and this is easy in XP ... MD> as a database with a driver: the ODBC driver manager cannot find ... MD> only difference to this matter between XP and win98? ...
    (microsoft.public.data.odbc)
  • Re: Opening Excel from Access
    ... I have a form with a textbox to hold the Excel file name and a command ... Dim MDBName As String, DefaultDirectory As String, SQLStg As String ... If MsgBox("Do you want to use this database in future?", ...
    (comp.databases.ms-access)
  • Re: commiting changes made to a typed dataset
    ... submits them to an sqlserver database. ... finally all the added rows have to be submitted to the datasource ... is the datasource of the dataset the Excel file or the sql ... but this is a classic ADO newsgroup. ...
    (microsoft.public.data.ado)
  • Re: Opening Excel from Access
    ... Please post the code that is in the Excel file. ... There is some code in the Excel application which refers to the Database ... Dim XLFilePath As String ... Dim Msg As String ...
    (comp.databases.ms-access)
  • RE: Error in docmd.transferspreadsheet?
    ... Try to create a new Excel file, and add some simple fields/data to test ... try on a different client machine with Access 2003 ... If the issue still occurs, please try a different SQL Server as backend ... "restarting the database" I mean close and open the adp ...
    (microsoft.public.access.adp.sqlserver)