A Python way to get MS Access table column information?

Diez B. Roggisch deets at nospam.web.de
Mon Oct 15 11:28:31 EDT 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 

http://www.python.org/dev/peps/pep-0249/

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

Diez



More information about the Python-list mailing list