importceODBC
connect=ceODBC.connect("""DSN=mydatabase;SERVER=xxx.xxx.x.xxx;
DRIVER={SQLServer};UID=user;PWD=password""",autocommit=True)cursor=connect.cursor()cursor.execute("""
CREATE TABLE mydatabase.dbo.Vision_TempTable
(
CustId bigint,
PayProcId int,
WebUserId bigint,
SubTypeId bigint,
PayAmt decimal(18,2),
Paydate datetime,
PayType varchar(1),
DateCreated datetime,
PayStatus varchar(1),
Account varchar(30),
V_Account varchar(30)
)""")#Createa temp table which will be usedinthe SP insert
connect.commit()f=open('F:/clients/UTA/Vision/Data/ExternalPay_Data/lbox.txt')CUST_ID=44PAYPROCID=4SUBTYPE_ID=64WEBUSER_ID=2432PAYTYPE='C'PAYSTATUS='J'forlineinf:#parse a text file an