top of page
# --- Script Calls SQL_Insert function from Module
# ----- SQL_Insert Moldule opens and inserts data
# ----- Uses SQL Authetication no Windows Accounts
# --- Import Custom SQL Module ---|
import csv
import sys
sys.path.append(r"C:\PYTHON\modules")
import SQL_Insert
# --- Set Parameters for SQL Connection and Insert ---
csv_file = 'C:/PYTHON/Sample/Insert_Customer_Info.csv'
server='Blacky'
database='Test'
table='Customer_Info'
username='sa'
password='XXXXX'
# --- Module Function Call ---
SQL_Insert.import_csv_to_sql(csv_file, server, database, table, username, password)
SQL Insert
bottom of page