Hi all,

I am trying to create a database Puller! it will extract data using SQL via the medium of Excel lol without the user having any knowledge of SQL.

However i really need to obtain all the table names from a given Database.
The database' filepath is located in Cell B2 so given that can anyone help me with the code?

I'll get ya started lol:

Dim db as Database
Dim MyDb as string

MyDb = Range("B2").value
Set db = OpenDatabase(MyDb)
That's all i got lol!!!

I'm thinking it could make use of this SQL Script:
SELECT *
FROM all_tab_columns
WHERE Table_Name IS NOT NULL
but thats something i use in Oracle Developer to obtain table names

please hep & Ta for reading my thread