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