Pyodbc create table doesn't work

Python Help
1

Hi,

The program doesnt return any errors but it doesnt create table in SQL Server. Can anybody help?

import pyodbc

server = ‘007-KOMPUTER\SERVER007’
database = ‘master’
username = ‘sa’
password = ‘Admin1234’
cnxn = pyodbc.connect(‘DRIVER={ODBC Driver 17 for SQL Server};SERVER=’+server+’;DATABASE=’+database+’;UID=’+username+’;PWD=’+ password)
cursor = cnxn.cursor()

server2 = ‘007-KOMPUTER\SERVER007’
database2 = ‘model’
username2 = ‘sa’
password2 = ‘Admin1234’
cnxn2 = pyodbc.connect(‘DRIVER={ODBC Driver 17 for SQL Server};SERVER=’+server2+’;DATABASE=’+database2+’;UID=’+username2+’;PWD=’+ password2)
cursor2 = cnxn.cursor()

cursor.execute(‘SELECT * FROM master.dbo.Sales_data’)
result = cursor.fetchall()

cursor2.execute(’’‘CREATE TABLE model.dbo.Sales_data (id varchar(64), status varchar(64), revenue varchar(64), customer_volume varchar(64),internet varchar(64),speed varchar(64),region varchar(64),sales varchar(64),channel varchar(64),offer varchar(64),yerar varchar(64),month varchar(64),week varchar(64),day varchar(64),sale_date varchar(64),ins_date varchar(64),bundle varchar(64),action_type varchar(64),category varchar(64))’’’)
cnxn2.execute(‘commit’)
cnxn2.commit()

#Regards
#Michal