A Python way to get MS Access table column information?

goldtech goldtech at worldpost.com
Mon Oct 15 11:16:17 EDT 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.

Using just Python and OBDC is there a way? Maybe Win32com?

Thanks




More information about the Python-list mailing list