import pyodbc
import pandas as pd

cnxn = pyodbc.connect(driver='{ODBC Driver 17 for SQL Server}', server='xxx' ,database='xxxx', trusted_connection = 'yes')

data = pd.read_sql('SELECT * FROM CoreRef.AddressUsageType',cnxn)

data.to_excel('The_Book.xlsx')