This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
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


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
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: 1131

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