Michael,
Try adding a ToUpper() to them before saving to the SQL table. It seems I have to do this whenever I move them from Fox. The format is different.
Tim
>I have fox tables that have ID columns of type double that I converted to C(36) and repopulated with a guid value and cascaded those values down to child tables. I do a query via OleDbAdapter to load said tables into memory in my C# app.
>
>I created a copy of said table in Sql Server and the ID column is of type uniquidentifer. When I try and move the table to the server from the dataset via a Bulk Copy - WriteToServer() call I get an error "The given value from the data source cannot be converted to type uniqueidentifier of the specified column".
>
>So I went back and made my fox columns type varbinary and casted the guid values to a type Q. Repeated the same process and got same error.
>
>What do I need to do to get the data type conversion to work? Fox has no problem with the guid and I can see them in the column with the dataset XML visualizer.
>
>Thanks all,
>
>MW
Timothy Bryan