>I sorta meant that as a test. I don't know how many records you are working with but some testing would find the answer to how they need to be changed in order to fit into SQL. I have just done a ToUpper() and they went right in, but it would depend on the format you have. For instance do they look like this:
> {1C285071-CB16-496a-B800-C9C1FC4DAA3C}
>
>I find it very interesting about the 4 in the 15th position Charles mentioned. I had never heard of that and don't know what that means, but I see it holds true.
>Tim
My understanding is it means the guid was created with the Microsoft algorithm.
>
>>
>>So you are saying execute a ToUpper() on each guid type column in every row before I call the Bulk Copy? I guess that means leave the fox table type as C(36) and not a varbinary.
>>
>>That could be really slow depending on the number of guid columns times the number of rows in each data table. I was hoping more to know which data type I can leave the fox tables guid columns in and have it move from fox to C# dataset to Sql table without any major hoops. I guess there is none.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.