85BtuxT0

1import sqlite3
2import pyodbc
3
4tempConn = sqlite3.connect('example.db')
5c = tempConn.cursor()
6c.execute(
7    ''' CREATE TABLE IF NOT EXISTS addresses
8    (
9         amt NUMERIC,
10         city text,
11         statecode text,
12         zipcode text
13    )
14    '''
15)
16conn = pyodbc.connect(
17    r'DRIVER={ODBC Driver 11 for SQL Server};'
18    r'SERVER=<server>;'
19    r'DATABASE=<database>;'
20    r'UID=user;'
21    r'PWD=password'
22)
23
24conn.setdecoding(pyodbc.SQL_CHAR, encoding='utf-8')
25conn.setdecoding(pyodbc.SQL_WCHAR, encoding='utf-8')
26conn.setencoding(encoding='utf-8')
27
28cursor = conn.cursor()
29
30cursor.execute("SELECT TOP 10 fd.Amt, fd.City, fd.StateCode, fd.ZipCode FROM <large table> AS fd")
31index = 1
32rows = cursor.fetchall()
33for row in rows:
34    print('Row Data:')
35    print(row)
36    print('')
37    try:
38        c.executemany("INSERT INTO addresses VALUES (?,?,?,?)", row)
39        rowcount = c.execute("SELECT COUNT(*) FROM addresses")
40    except sqlite3.Error as er:
41        print('er: ', er.Message)
42    print(rowcount)