Write SQLServer Uniqueidentifier to table

[bjreb]

I have an insert into query based on a recordset from a stored procedure. The recordset contains a field that has a uniqueidentifier. How can I insert this into my table. It just does not want to work.

Insert into [Copy Of CurrentData](TXT_JPEG_KEY)
Values ({6635F4F8-D827-45B4-85C0-0FD6E5388359})

What datatype should TXT_JPEG_KEY Be?

Thanks
Andy

 

[WayneRyan]

Andy,

To me it looks like it is what SQL Server can represent as VarBinary(16).
Is it just a "random" primary key?

You can have the Stored Procedure "Cast" it, but it definitely won't be numeric.
You could cast it as NVarchar(16) in the stored stored procedure and see
what Access thinks of it as a text field.

It won't be "human readable" as text, but it should serve as a valid Key Field.

hth,
Wayne