Hi Charles.

>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?

You could temporarily set TYPEMAP.DEFAULT to .T. for the uniqueidentifier record and .F. for the other records with LOCALTYPE = 'C', but then you'd have the same issue with your other non-ID character fields: having to manually change the default.

>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)

I suggest tracing the code in BulkXMLLoad.PRG to see what's going on.

Doug