java, m$ access, sql?

Thread view:

boco - 30 Nov 2005 22:38 GMT

Here is what I am trying to do. If someone could enlighten me on how to
accomplish it, I would be endlessly grateful. I have a relatively large m$
access database that I would like to convert over to an sql database. I
would like to be able to access this sql database from within a java
application. The java application will not have access to the internet, so
the sql db should be read from a file (data.sql?). Is this possible, and
how?

Reply to this Message

EricF - 01 Dec 2005 06:08 GMT

>Here is what I am trying to do. If someone could enlighten me on how to
>accomplish it, I would be endlessly grateful. I have a relatively large m$
[quoted text clipped - 3 lines]
>the sql db should be read from a file (data.sql?). Is this possible, and
>how?

It's not clear to me what you are trying to accomplsh. Access is (kind of) a
sql database. You can access a ms Access database with Java using the
JDBC-ODBC (or is it ODBC-JDBC) bridge. (It won't scale well in Access but that
may not be an issue.) If you import the db to another database, you should be
able to use JDBC. What does this have to do with the internet? But if you want
to read the db from a file, you can export the db to a file and read it. If
you need to read from a file, why convert to a different DBMS? Need joins?
Don't read it from a file.

Eric

Reply to this Message

java, m$ access, sql?

Free Magazines