Including column names when converting an .mdb file to .csv in Python

Question

I've managed to convert a .mdb file to .csv, based on this post: How to export MS Access table into a csv file in Python using e.g. pypyodbc.

However, I can not get the metadata (column name) from the original file. Does anyone have a clue on how to do that?

Thanks!

Have you had a look at this stackoverflow.com/questions/15098747/… ? — David
– David, Commented Mar 20, 2020 at 0:13

Parfait · Accepted Answer · 2020-03-19 22:33:54Z

3

Simply retrieve headers from cursor.description where you will call writerow just before iterating through cursor results:

# OPEN CSV AND ITERATE THROUGH RESULTS
with open('CSVDatabaseWithHeaders.csv', 'w', newline='') as f:
    writer = csv.writer(f)    
    # ADD LINE BEFORE LOOP
    writer.writerow([i[0] for i in cur.description])  

    for row in cur.fetchall() :
        writer.writerow(row)

answered Mar 19, 2020 at 22:33

Parfait

108k19 gold badges103 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Coraline Over a year ago

Perfect! Thank you!

Collectives™ on Stack Overflow

Including column names when converting an .mdb file to .csv in Python

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related