Retrieve list of tables from Microsoft Access database (mdb) using JaDeBeAPI and UCanAccess from python

Question

I'm trying to retrieve a list of tables from an MS Access mdb database file from Python using JayDeBeApi combined with UCanAccess. Querying the database works fine, though I cannot find out how top list all tables. I've been googling and trying for days now, but was not able to find a solution.

Anyone can help?

Thanks, best, Max

Please provide enough code so others can better understand or reproduce the problem. — Community
– Community Bot, Commented Mar 17, 2022 at 13:13
Does this answer your question? Python odbc; how to find all tables in an odbc — June7
– June7, Commented Mar 17, 2022 at 17:26

Aienos_900 · Accepted Answer · 2022-06-30 17:12:05Z

2

Once you have created the connection using Import pyodbc: run this

for i in cursor.tables(tableType='Table'):
    print(i.table_name)

That should give you a list of all the tables in the MS access Db

answered Jun 30, 2022 at 17:12

Aienos_900

315 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Retrieve list of tables from Microsoft Access database (mdb) using JaDeBeAPI and UCanAccess from python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related