Obtain Access Table Names via Excel

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:

Please Login or Register  to view this content.

That's all i got lol!!!

I'm thinking it could make use of this SQL Script:

Please Login or Register  to view this content.

but thats something i use in Oracle Developer to obtain table names

please hep & Ta for reading my thread

I actually did it on my own!!!

get in for those who care here's how:

Please Login or Register  to view this content.

Damn That feels so good!!!! get in!!!

Nice one Stuie!!!

You actually end up getting these weird other tables too so i re-wrote it to exlcude them. Here it is:

Please Login or Register  to view this content.

HTH

Great

Glad i could help maybe this will help to:

it extracts all of the recordsets from a given Table:

Please Login or Register  to view this content.

or there is this one which allows you to specify a field and a criteria in that field using some SQL:

Please Login or Register  to view this content.

HTH