Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

getting the list of table from msaccess database

 
ratna prasad kakani
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
use it like this:

[ July 23, 2003: Message edited by: jiayu gao ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic