Python 3 Pandas Script to Export MySQL Server Database Tables to CSV File Using pyodbc Library Full Project For Beginners



pip install pandas


pip install pyodbc



import pandas as pd
import pyodbc 

conn = pyodbc.connect('Driver={SQL Server};'

sql_query = pd.read_sql_query(''' 
                              select * from test_database.dbo.product
                              ,conn) # here, the 'conn' is the variable that contains your database connection information from step 2

df = pd.DataFrame(sql_query)
df.to_csv (r'C:\Users\Ron\Desktop\exported_data.csv', index = False) # place 'r' before the path name


Leave a Reply