Obtain Access Table Names via Excel

[Macdave_19]

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

[Macdave_19]

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!!!

[Stuie]

always feels better to work it out yourself, nice one

[Macdave_19]

Nice one Stuie!!!

[Macdave_19]

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

[Stuie]

i will keep this post in mind as have a project coming up at work soon where i will need to extract a couple of data tables, i would normally just use a data import but i would rather code everything that way you have more control, so you given me a great idea for that

[Macdave_19]

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