Convert some database data (SQL Table) to .csv format

Question

I want to convert some database data to .csv format. At the beginning, I create a connection with a database then create a cursor instance, send query through that cursor instance, fetch your data & close the connection. My problem is that I can't visualize the headers of the table, I get just the content.

import pyodbc
import csv

connection = pyodbc.connect("Driver={ODBC Driver 11 for SQL Server};"
                  "Server=*****;"
                  "Database=****;"
                  "uid=****;pwd=****")

 cursor = connection.cursor()
 cursor.execute("Select * from Table")
 data=cursor.fetchall()

 with open('test.csv', 'w', newline= '') as f:
a = csv.writer(f, delimiter=',')
a.writerows(data)  
cursor.close()
connection.close()

Zaynul Abadin Tuhin · Accepted Answer · 2019-05-29 09:39:51Z

2

use pandas for reading data from db to export into csv

import pandas as pd
sql='Select * from Table'
df= pd.read_sql(sql,sql_connection)
df.to_csv('csv_filename')

edited May 29, 2019 at 9:39

answered May 29, 2019 at 9:26

Zaynul Abadin Tuhin

32.1k6 gold badges37 silver badges66 bronze badges

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

Collectives™ on Stack Overflow

Convert some database data (SQL Table) to .csv format

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related