Skip to content

Instantly share code, notes, and snippets.

@jeakwon

jeakwon/mssql_connect.py

Created May 11, 2020 08:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jeakwon/c8e458319646dcb2dd1f409e7489885e to your computer and use it in GitHub Desktop.
Save jeakwon/c8e458319646dcb2dd1f409e7489885e to your computer and use it in GitHub Desktop.
Download ZIP
sqlalchemy, pyodbc, mssql
Raw
mssql_connect.py
import pandas as pd
import pyodbc
from sqlalchemy import create_engine
engine = create_engine("mssql+pyodbc://DESKTOP-R5QA5N1/test?driver=SQL+Server+Native+Client+11.0")
df = pd.DataFrame([1])
df.to_sql('test', con=engine)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment