aspose file tools*
The moose likes JDBC and the fly likes getting the list of table from msaccess database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "getting the list of table from msaccess database" Watch "getting the list of table from msaccess database" New topic
Author

getting the list of table from msaccess database

ratna prasad kakani
Greenhorn

Joined: May 15, 2003
Posts: 3
hello,
i want to get the list of table from msaccess database,simply like "select * from tab" in oracle. if possible pls help me else is there any other way pls say to me
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1121

Hi Ratna,
Excuse me if I am stating the obvious, but you can use the DatabaseMetaData interface. Works for me on my Windows98 machine with J2SE SDK 1.4.1 (using the JDBC-ODBC driver that is included with the SDK) and Micro$oft Access 2000.
Good Luck,
Avi.
ratna prasad kakani
Greenhorn

Joined: May 15, 2003
Posts: 3
thanks avi,
my system is windows 2000 i had used databasemetadata but i am not getting the table name except that database name and its class path
jiayu gao
Greenhorn

Joined: Jul 16, 2003
Posts: 9
use it like this:

[ July 23, 2003: Message edited by: jiayu gao ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: getting the list of table from msaccess database
 
Similar Threads
How to connect msaccess database from myeclipse IDE tools
URGENT !! JDBC driver help. Reply asap
Changing from MSAccess to MySQL
user authentication
How to connect Msaccess from myeclipse