Python sqlite qmark create table

[kurtf]

Hope somebody could help me with the creation of a table in sqlite3 from python.

I am developing an application that allows a user to import a data file and insert the data into a sqlite3 database.

I want the names of the fields to be derived from the first row of the file.

I have been trying to perform this with code like:

# CODE BEGIN
import sqlite3

con = sqlite3.connect(":memory:")
cur = con.cursor()

# Create the table
con.execute("CREATE TABLE table1 (?, ?)", ('one', 'two'))
con.close()
# CODE FINISH

This throws up the following error:

# ERROR BEGIN
Traceback (most recent call last):
File "/Users/xxx/Documents/Projects/temp.py", line 7, in <module>
con.execute("CREATE TABLE table1 (?, ?)", ('one', 'two'))
OperationalError: near "?": syntax error
# ERROR FINISH

Any help or suggestions on how to get the field names from the file dynamically inserted as the field names on the creation of the table would be much appreciated. Just for further information the names 'one' and 'two' are used as an example but in reality are stripped from the data file as the file is read into python.

Thanks in advance