python 3.x - Pypyodbc: return field description of specific field in specific MS Access table? -
i'm trying retrieve description (or other property) of field in ms access database.
something in recordset of vba:
for each field in recordset.fields debug.print "name: " & field.name debug.print "type: " & field.type debug.print "size: " & field.actualsize debug.print "value: " & field.value next
is there way how pypyodbc (or other odbc module)?
the cursor.description attribute give following information each column in cursor:
name
type_code
display_size
internal_size
precision
scale
null_ok
for other information on fields in access table need use com create access dao object , pull information fields
collection of table's tabledef
object. see
accessing microsoft automation objects python
for more information on using com python on windows.
Comments
Post a Comment