File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Elasticsearch in Action
this week in the
JDBC and Relational Databases
How to get the DB dump from MS ACCESS using java code?
Joined: May 23, 2008
Nov 18, 2010 10:03:38
I need to get the database dump from Ms Access database, using
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.
Joined: Oct 23, 2005
Nov 18, 2010 11:11:57
In Access, you can export the tables to
. In Java, though, you would have to query each table and pull each record. The Meta Data
classes can assist in automating this, though.
[OCA 8 Book]
Joined: Dec 20, 2006
Nov 18, 2010 11:44:25
Since Access is a file based database, can't you simply copy your database file(s)?
OCUP UML fundamental and ITIL foundation
subject: How to get the DB dump from MS ACCESS using java code?
How to download a file from database
Get index of a row
read data from MS Access db file in UNIX, using JAVA
Quering the ResultSet
JSP/Servlet With MS Excel?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015