This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes How to get the DB dump from MS ACCESS using java code? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to get the DB dump from MS ACCESS using java code?" Watch "How to get the DB dump from MS ACCESS using java code?" New topic
Author

How to get the DB dump from MS ACCESS using java code?

prabhu pandurangan
Ranch Hand

Joined: May 23, 2008
Posts: 120
Hi All,

I need to get the database dump from Ms Access database, using java standalone application, using Java Runtime exec. process.

We have an functionality in Mysql 'mysqldump' but i do not know we have a similar kind of function in MS Access.

Kindly help me out in this. It would be better if i can get some sample code.

Regards,
Prabhu
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3700
    
    5

In Access, you can export the tables to CSV. In Java, though, you would have to query each table and pull each record. The Meta Data JDBC classes can assist in automating this, though.


My Blog: Down Home Country Coding with Scott Selikoff
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2491
    
    8

Since Access is a file based database, can't you simply copy your database file(s)?

OCUP UML fundamental and ITIL foundation
youtube channel
 
 
subject: How to get the DB dump from MS ACCESS using java code?
 
Similar Threads
Get index of a row
Quering the ResultSet
How to download a file from database
read data from MS Access db file in UNIX, using JAVA
JSP/Servlet With MS Excel?