BartlebyScrivener wrote:
> Hello, I'm new to python and trying to get records from an MSAccess
> database using mxODBC. It works, but the output is not formatted the
> way I want it.
>
> Here's the script:
>
> import mx.ODBC.Windows as odbc
>
> driv='DRIVER={Microsoft Access Driver (*.mdb)};DBQ=
Works!!
Thank you all so much. I didn't know it was coming back as a tuple, and
I'm sure that would have taken me four hours to figure out.
Appreciate it!
bs
Chris Curvey wrote:
> mxODBC implements the Python DB-API spec, which states that each "row"
> of query results is returned as
mxODBC implements the Python DB-API spec, which states that each "row"
of query results is returned as a tuple. If you want the data
displayed differently, you can do it yourself.
for row in rows:
print "\t".join(row)
should do it.
--
http://mail.python.org/mailman/listinfo/python-list
BartlebyScrivener wrote:
> Hello, I'm new to python and trying to get records from an MSAccess
> database using mxODBC. It works, but the output is not formatted the
> way I want it.
>
> Here's the script:
>
> import mx.ODBC.Windows as odbc
>
> driv='DRIVER={Microsoft Access Driver (*.mdb)};DBQ=d:
Hello, I'm new to python and trying to get records from an MSAccess
database using mxODBC. It works, but the output is not formatted the
way I want it.
Here's the script:
import mx.ODBC.Windows as odbc
driv='DRIVER={Microsoft Access Driver (*.mdb)};DBQ=d:/Access
Databases/Quotations2005'
conn =