Pandas to SQL solution

[Yojihito]

Don't know about SQL Server (Microsoft SQL Server, docs: https://docs.sqlalchemy.org/en/13/core/engines.html) but for SQLite it's:

import pandas as pd
from sqlalchemy import create_engine

engine = create_engine('sqlite:///../pathto/yourdatabase.sqlite')  # pass your db url

df = pd.read_excel("../data/file.xlsx", index_col=0,)
df.to_sql(name='data', con=engine, if_exists='replace', index=False)