Thread: Fetch list of table names in access to a record set
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
  
Posts: 2,253
Default Fetch list of table names in access to a record set
try:

Set oRst = oCon.OpenSchema(20) 'adSchemaTables



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Prashantha Weerakoon wrote :

Hello all

What is the sql query that fetches all the table names that exist in
the access database...

i need to fetch this to a record set and i am uisng java with odbc to
access ms access?


/thanks in advance
PRash
Reply With QuoteReply With Quote