Inserting data from a csv file in an existing table

[Bloodofme]

Hi,

first of all... sorry for my bad english.

i have several csv files which i want to migrate in one db. The problem is that the source data has no unique fields. So by creating the db table from the first cvs file i have create a new column "id" as the primary key. No problems until that.

Now when i try to insert data from the other csv files into the table i got a warning like "Attempt to insert null into a non-nullable column..:" Ok, thats why there is no value in the new data for the primary key, right?

Is it possible to insert the data and automaticaly let incremental the values for "id"?

[Villeroy]

Make "id" auto-value. Call "Edit..." from the table's context menu.