My favorites
▼
|
Sign in
pyodbc
Python ODBC library
Project Home
Downloads
Wiki
READ-ONLY: This project has been
archived
. For more information see
this post
.
Search
Search within:
All issues
Open issues
New issues
Issues to verify
for
Advanced search
Search tips
Subscriptions
Issue
96
attachment: ivoirdata2.py
(656 bytes)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
# -*- coding: utf-8 -*-
import pyodbc
import csv
conn=pyodbc.connect('DSN=lintry')
sql="SELECT id_nomenclator,id_loca,collecteur,n_coll,bdcsrs,rejj,recmm,reaaaa FROM cvc414"
cursor=conn.cursor()
cursor.execute(sql)
rows=cursor.fetchall()
i=0
csv_file = csv.writer(open('file.csv', 'w'), delimiter=',')
for records in rows:
data=[]
i=i+1
data.append(records.bdcsrs)
data.append(records.id_nomenclator)
data.append(records.collecteur)
data.append(records.n_coll)
data.append(records.id_loca)
data.append(records.rejj)
data.append(records.recmm)
data.append(records.reaaaa)
csv_file.writerow(data)
if i==100:
print records.id_loca
exit()
Powered by
Google Project Hosting