Extract tables with specific parameters from MSQL ( Csv file ) ...

Hi guys !!!

I'm new on python programming, I think I learn fast ( I hope hehehehe ), I create this little script to connect to a database extract some tables with specific parameters, and put them in a CSV file:

import pandas as pd
import pyodbc
import csv
conn = pyodbc.connect('Driver={SQL Server};'
'Localhost;'
'Username = test;'
'password = test;'
'Database=TEST;'
'Trusted_Connection=yes;')
sql_query = pd.read_sql_query('''
select * from TEST.dbo.TABLE01
'''
,conn)
df = pd.DataFrame(sql_query)
df.to_csv (r'D:\\TABLE01.csv', index = False, sep = ',', quotechar = '"', quoting=csv.QUOTE_ALL)​

But, I won't add the option to offer me native export from SQL:



In specific:

• Locale ( Spanish (Mexico) )
• Code page: 1252 (ANSI - Latin I)
  

Can you help me to add these lines to my code ???

Thanks so much, guys !!!