Author
How to create MSAccess file(.mdb) using java
Soumayajit Hazra
Greenhorn
Joined: Nov 13, 2006
Posts: 8
I am trying to create access database at runtime. For that purpose we need to create .mdb file runtime. How to do this? please help...
Jeanne Boyarsky
internet detective
Marshal
Joined: May 26, 2003
Posts: 26168
I don't think it is possible to do this purely in Java. You could call an operating system script using Runtime.exec() and then use a batch/shell script.
[Blog ] [JavaRanch FAQ ] [How To Ask Questions The Smart Way ] [Book Promos ]
Blogging on Certs: SCEA Part 1 , Part 2 & 3 , Core Spring 3 , OCAJP , OCPJP beta , TOGAF part 1 and part 2
Wei Dai
Ranch Hand
Joined: Jun 22, 2005
Posts: 81
Free solution: prepare a blank mdb file, then copy it as the destination file, then use dsn-less jdbc url to access it. Commercial solution: use the CREATE DATABASE sql at http://www.hxtt.com/access/sqlsyntax.html#createdatabase .
Ulf Dittmer
Marshal
Joined: Mar 22, 2005
Posts: 35232
posted Nov 18, 2006 09:00:00
0
The Jackcess library provides a pure-Java way to create, read and write MDB files in Access 2000 format.
Android apps – ImageJ plugins – Java web charts
subject: How to create MSAccess file(.mdb) using java