Import sqlite help

I'm struggling to achieve what seems to me should be a simple goal.

I have a long list of vaule I want imported in to a database in one column with many rows.

I have no problems getting the data in in one row and many colums, but I can't figure out how to do it the other way round.

Is that possible??? if not is it possible to alter the table once the data in imported to swap开发者_运维知识库 to a manyx1 from a 1xmany table.

Thanks in advance.

---

As with any other database, if you want 10 rows of data, you have to perform 10 insert operations. So you would just loop over your list of values and for each one insert a new row into the database.