EXPORT FROM SQL SERVER TO CSV

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

EXPORT FROM SQL SERVER TO CSV

woooee
Verb Conjugator

Posts: 529

Threads: 0

Joined: Feb 2018

Reputation: 35

Apr-17-2018, 04:48 PM (This post was last modified: Apr-17-2018, 04:50 PM by woooee.)

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

Find

Messages In This Thread

EXPORT FROM SQL SERVER TO CSV - by PYTHONDUDE - Apr-17-2018, 04:23 PM

RE: EXPORT FROM SQL SERVER TO CSV - by woooee - Apr-17-2018, 04:48 PM

RE: EXPORT FROM SQL SERVER TO CSV - by PYTHONDUDE - Apr-17-2018, 06:37 PM

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,938	Jul-14-2021, 01:32 PM Last Post: sivareddy

Users browsing this thread: 1 Guest(s)

View a Printable Version

EXPORT FROM SQL SERVER TO CSV

User Panel Messages

Announcements