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 -- http://mail.python.org/mailman/listinfo/python-list
