Python

Connecting to SQL databse and inseting the data using Python

# Azure SQL Database connection details

server = 'ServrerName'

database = 'DatabaseName'  # Replace with your database name

username = 'UserId'

password = 'Password'

driver = 'ODBC Driver 17 for SQL Server'

# Create the connection string

connection_string = f'mssql+pyodbc://{username}:{password}@{server}/{database}?driver={driver}'

# Create the SQLAlchemy engine

engine = create_engine(connection_string)

# Insert the data into the Azure SQL Database

partspec_insert.to_sql('Part', con=engine,schema='LSQ', if_exists='append', index=False)