Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import csv
- import pyodbc
- conn = pyodbc.connect('DSN=CData Facebook Source Sys;User=X;Password=Y')
- crsr = conn.cursor()
- crsr.execute("SELECT FromName, Message, FROM Wall WHERE Target = 'CNNee'")
- rows = crsr.fetchall()
- for row in rows:
- print(row.FromName, row.Message)
- # rows = crsr.execute()
- with open(r'C:\Users\user1\Desktop\CNNee.csv', 'w', newline='', encoding='utf-8') as csvfile:
- writer = csv.writer(csvfile)
- writer.writerow([x[0] for x in crsr.description]) # column headers
- for row in rows:
- writer.writerow(row)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement