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
> 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
That at least for other DBs gives the needed info, and it seems it's
More information about the Python-list