>Hi Charles.
>
>>uniqueidentifier is not an option on the dropdown. I thought I might get it on there by fiddling the typemap table to make uniqueidentifier one of the choices for character (in place of text)
>>but when I rebuild the app I get an operator/operand type mismatch ( which it is technically as only a very specific string would be seen by SQL as a uniqueidentifier.
>
>I looked into this. It's a goofy error caused by the TYPEMAP table already being open (likely because you added the uniqueidentifier record to it). I've fixed that but in the meantime, you should be able to CLOSE DATA ALL before running the Upsizing Wizard and it should work.
>
>A couple of other things:
>
>- I added several missing data types: uniqueidentifier, ntext, nchar, nvarchar, etc.
>- There's a weird versioning thing in the TYPEMAP table and associated code. I've taken care of that too, but in the meantime, you probably have to put "SQL Server4x" into the SERVER column of the new record in TYPEMAP.
>
>Doug

Thanks a lot Doug, I will give all this a try. Since I have about 400 columns that are c(36) nocptrans can you think of a good way to set the default for those to uniqueid rather than changing the mapping by hand on each one?

And do you know anything about the data type mismatch that I get just trying to use bulkxmlload into a table with uniqueidentifiers when the VFP cursor column is c(36) nocptrans (I'm assuming I'll get the same problem if the upsizer creates a UID column and I have bulk insert checked in the wizard)