Re: [TCLUG:3217] MS AccessDB files under Unix

[Richard Seymour <rseymour@anarchysoftware.com>]

There may be a better option than this, but I just converted a small
database from Access to MySql. I found a Visual Basic Script that created
the SQL statements needed to create the tables and insert the records. I
ran this script from access and then had a text file that I could execute
from MySQL. Worked like a charm. If your data set is small and you can
batch things up, this kind of approach works. Let me know if you want to
take a look at the Visual Basic Script that I found.

On Fri, 8 Jan 1999 schewe@tcfreenet.org wrote:

> Does anyone know of a way to read MS Access files under Unix.  Here's
> the situation.  I'm working on some software written in java that gets
> it's data through jdbc/odbc from a MS Access database.  I need to be
> able to do this all on a Sun Workstation running Solaris 2.6.  Does
> anyone have something that could say, convert it to a databse that runs
> under Solaris and has a jdbc driver or a driver that could read the
> database as is?  Thanks lots.
> -- 
> Jon Schewe
> schewe@tcfreenet.org
> http://tcfreenet.org/~schewe
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tclug-list-unsubscribe@listserv.real-time.com
> For additional commands, e-mail: tclug-list-help@listserv.real-time.com
> Try our website: http://tclug.real-time.com
> 

--
Richard Seymour, Anarchy Software, Inc.
anarchy@anarchysoftware.com

The opinions expressed are those of my employer, not my own.