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

Popular posts from this blog

javascript - Slick Slider width recalculation -

jsf - PrimeFaces Datatable - What is f:facet actually doing? -

http - Safari render HTML as received -