import pyodbc

cnxn = pyodbc.connect('DSN=hoge; UID=hoge; PWD=hoge')
cursor = cnxn.cursor()
cursor.execute(SELECT hogehoge FROM @hogehoge WHERE hogehoge)
rows= cursor.fetchall()
array_format = np.array(rows)
df1 = pd.DataFrame(array_format)

Recommended Posts