A Python way to get MS Access table column information?

Diez B. Roggisch deets at nospam.web.de
Mon Oct 15 17:28:31 CEST 2007

goldtech wrote:

> Using Python and OBDC in MS-Access DBs. So, I'm able to run SQL
> statements from Python on an Access DB.
> Is there an SQL statement that will give me column information? For a
> table I want to know the data type and of course colum/Attribute name
> for each column.
> So far the answer has been "no". VB or some other tool is needed to do
> that I'm told.

Who said that? Did you check the cursor objects description-property, as
described in 


That at least for other DBs gives the needed info, and it seems it's


More information about the Python-list mailing list