The moose likes JDBC and Relational Databases 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 and Relational Databases
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: 1138
    
    1

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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: getting the list of table from msaccess database
 
It's not a secret anymore!