Any odbc datasource can be accessed from jdbc using the odbc bridge, providing the odbc drivers exist for the datasource type. Specifically, if the connection/query is handled via a web app servlet, only the web server hosting the servlet needs to have the relevant odbc driver installed (i.e. NOT the web client).
I did something similar recently, by retrieving data from Excel spreadsheets (you can also update an xls in the same manner, but that's another tale) and pushing it into Sybase while displaying the data back to the user's web page. just treat the Access db in your jdbc connection and query code as you would any other db and the rest should be straightforward. It ain't rocket science or StarTrek and odbc's still a piece of junk compared to true native db drivers, but it does provide a solution to the sub-Enterprise datasources that still inhabit Bill's World... Hope this helps. Austin > from: "RUTHERFURD, Michael" <[EMAIL PROTECTED]> > date: Wed, 11 Sep 2002 01:51:27 > to: [EMAIL PROTECTED] > subject: Re: Ms Access and Java Servlets-Applet > > > I'm not an MS person, but pretty much all I've heard about using > > Access with servlets can be summed up in one word: Don't. (Yes, a > > contraction counts as one word! :-) > > > > Milt Epstein > > Milt, were any reasons given (technical, not evil empire)? I'm interested as > I'm currently having to simulate the prod DB in ms access (the prod db will > be a funky teradata box but they haven't got the hardware yet). > > Michael Rutherfurd > > ___________________________________________________________________________ > To unsubscribe, send email to [EMAIL PROTECTED] and include in the body > of the message "signoff SERVLET-INTEREST". > > Archives: http://archives.java.sun.com/archives/servlet-interest.html > Resources: http://java.sun.com/products/servlet/external-resources.html > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html > > from: "RUTHERFURD, Michael" <[EMAIL PROTECTED]> > date: Wed, 11 Sep 2002 01:51:27 > to: [EMAIL PROTECTED] > subject: Re: Ms Access and Java Servlets-Applet > > > I'm not an MS person, but pretty much all I've heard about using > > Access with servlets can be summed up in one word: Don't. (Yes, a > > contraction counts as one word! :-) > > > > Milt Epstein > > Milt, were any reasons given (technical, not evil empire)? I'm interested as > I'm currently having to simulate the prod DB in ms access (the prod db will > be a funky teradata box but they haven't got the hardware yet). > > Michael Rutherfurd > > ___________________________________________________________________________ > To unsubscribe, send email to [EMAIL PROTECTED] and include in the body > of the message "signoff SERVLET-INTEREST". > > Archives: http://archives.java.sun.com/archives/servlet-interest.html > Resources: http://java.sun.com/products/servlet/external-resources.html > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html > ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
