Syntax for a static GUID in Jet SQL

[misfit815]

I'm trying to execute an INSERT query with a static GUID value, but
can't get the syntax right. Assuming that Col1 of Table1 is a GUID
field, what's the correct form of the following:

INSERT INTO Table1 (Col1, Col2... ColN)
SELECT '12345678-9ABC-DEF0-1234-56789ABCDEF0', Col2... ColN
FROM Table2

I've tried various combinations of ', ", #, {}... and can't seem to
find the answer. Thanks.

J

 

[Sylvain Lafontaine]

Not sure but I think that for JET, you need something like:

{guid {5FF51B8E-8A0C-11D2-BD7C-006008D242CD}}

Don't know if you must enclose this between single quotes or double quotes.
See also:

http://www.trigeminal.com/usenet/usenet011.asp?1033
http://www.trigeminal.com/code/guids.bas