I tried to remove cursor and used split to split csv record to columns
cr = csv.reader(open("D:/test.csv","r"))
for line in cr:
vlist = line.split(',')
but, getting below error:
AttributeError: 'list' object has no attribute 'split'
Any help on the code to split csv record to columns so that we can insert the same to table..
I could manage to write .csv to table, but it is picking only the last record in the csv file. Anything I am missing here to get complete record set in the file.
alist = 
for rows in cr:
to_db = [(rows),(rows)]
my insert statement - INSERT INTO ACT_T(ACT,DESC)VALUES(?,?)
Can you post your entire script? All i could see is that you are trying to add first two elements from the rows to the table.