|CSV import with auto-generated primary key [message #677448]
||Wed, 08 June 2011 10:48
Registered: July 2009
I load a CSV file into a table but DTP insists on each row in the file
having a primary key. But I want DTP to genewrate that.
The rows in the CSV file do not have a primary key. In the destination
table, the first column is defined as a non-null, auto-generated primary
key. I was hoping that when the first column in the CSV is empty, that
DTP will auto-generate that column. Instead, it gives and error stating
that a null value is being assigned to a non-null column.
Is there way to get DTP to auto-generate IDs during CSV import?
I am using DTP 1.9.
Powered by FUDForum
. Page generated in 0.02184 seconds