list table named from access database

[sal21]

I need to list all tables name from access database...

but only for table where left 2 is numeric. (see image)

note:
i use ADO and Vb6

[HansV]

Is it OK to use DAO?

[sal21]

Is it OK to use DAO?

no prob!

[HansV]

Actually, it doesn't matter.
Open a recordset with the following SQL.

If you use DAO:

Code: Select all

    SQL = "SELECT MSysObjects.Name FROM MSysObjects WHERE MSysObjects.Name Like '[0-9][0-9]*' AND MSysObjects.Type=1"

If you use ADODB:

Code: Select all

    SQL = "SELECT MSysObjects.Name FROM MSysObjects WHERE MSysObjects.Name Like '[0-9][0-9]%' AND MSysObjects.Type=1"