Win a copy of Android Programming: The Big Nerd Ranch Guide this week in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
prabhu pandurangan
Ranch Hand
Posts: 147
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author
Bartender
Posts: 4085
21
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Jan Cumps
Bartender
Posts: 2630
17
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Since Access is a file based database, can't you simply copy your database file(s)?
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!