Hi:
I have an Access 2003 adp where I'm importing comma delimited text into a
temporary table.This table has no primary key in that all fields have
duplicate data, therefore I only have read access to the data and the
recordset is uneditable.  That's o.k. in the temporary table, but once I
export it to a permanent table I need to define a primary key so I can edit,
add and delete data.  This is where I'm stumped.  When I export data to the
permanent table (which has a 'uniqueidentifier' field that represents the
primary key, I get a returned error message that says "unable to process
request because primary key can't contain Null values).  The temporary table
dosn't have a uniqueidentifier field but the master does.  How can I get to
master table to autimatically update uniqueidentifiers in that primary key
field upon export?
Thanks in advance,
Steve