Python Forum
EXPORT FROM SQL SERVER TO CSV
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
EXPORT FROM SQL SERVER TO CSV
#1
The below code works however, whenever it gets exported, the headers for each column is missing. I need it to include all headers please advise

import pyodbc
import csv

conn =("Driver={SQLSERVER Native Client 11.0};"
"Server = blah"
"database = mydb;"

cursor = coon.cursor()
sql = """Select top 5 * from mytable"""
cursor.execute(sql)

row = cursor.fetchall()
with open('test.csv', 'w', newline= '') as f:
a = csv.writer(f, delimiter=',')
a.writerows(rows

cursor.close()
Reply
#2
You write that row separately

with open('test.csv', 'w', newline= '') as f:
    a = csv.writer(f, delimiter=',')
    a.writerow(["Header 1", "Header 2"])  ## etc
    a.writerows(rows)  ## closing paren added 
Reply
#3
thank you that worked
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  How to take the tar backup files form remote server to local server sivareddy 0 1,871 Jul-14-2021, 01:32 PM
Last Post: sivareddy

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020