Hi All,

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..

Hi,

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:
     alist.append(rows)
     to_db = [(rows[0]),(rows[1])]
  

my insert statement - INSERT INTO ACT_T(ACT,DESC)VALUES(?,?)