@sendog3c First of all: welcome here...
For the future, if you want to post your code in this forum, use the button </> above,
it will help you to insert your code between two lines of three back quotes
c = conn.cursor()
# Create table
c.execute('''CREATE TABLE IF NOT EXISTS stocks (date text, trans text, symbol text, qty real, price real)''')
#c.execute('''CREATE TABLE stocks (date text, trans text, symbol text, qty real, price real)''')
# Insert a row of data
c.execute("INSERT INTO stocks VALUES ('2006-01-05','BUY','RHAT',100,35.14)")
# Save (commit) the changes
# We can also close the connection if we are done with it.
# Just be sure any changes have been committed or they will be lost.
Now, for your problem, use CREATE TABLE IF NOT EXISTS