Hi,
already tried to do this by appending a record in the typemap.dbf

localtype = C
Fulllocal = character
Remotetype = uniqueidentifier
Varlength = T (also tried with F)
Hasprec = F
Server SQL Server4x

Put the GUID's in a c(36)-field in Fox, but still can't chose uniqueidentifier in the wizard. The GUID's seem to be fine, have manually changed field type on the SQL-server. Tried to help me now by using the following:

* cursor curTab holds als the files to update
lcConn = "DRIVER=SQL Server;SERVER=(local);APP=Microsoft Visual FoxPro;WSID=DELLI;DATABASE=testdb;Trusted_Connection=Yes"
lnConnHandle = SQLSTRINGCONNECT(lcConn)

SCAN
	lcSql = "alter table " + RTRIM(Table_name) + " Alter COLUMN " + RTRIM(field_name) + " uniqueidentifier"
	lnRes = SQLEXEC(lnConnHandle, lcSql)
	IF lnRes != 1
		WAIT WINDOW "Error with table " + RTRIM(table_name)
	ENDIF
ENDSCAN

Using the wizard directly would be much more elegant. Any ideas how to achieve this?

TIA
-Dieter from Muenster, Germany