MS Access db (mdb): viewing table attributes
gau.tai at gmail.com
gau.tai at gmail.com
Fri Mar 10 15:48:14 EST 2006
That would be fine for me to switch to mxodbc, I've used it before and
it worked fine. But if I switch, do you know how I can get the column
names from the table? Maybe I'm not being clear with my question here.
I'm going to try again....
here's a table (it's in access):
=== tablename = mytable ===
id | user | pass | access privileges <-- these are the
column names I want
================================
0 bob 12345 admin/full
1 sam 53432 power user
4 mike 43234 guest
I know how to connect to the database.
I know how to get the table names.
How can I get the names of the columns for each table??
More information about the Python-list
mailing list