An upgrade of a proprietary management system has fallen on me, and I'm struggling to get back up. The data conversion went reasonably well, but one vital area was missed, and the vendor is of no help here, so I am left with no recourse but to hack into it in order to make everything right by the beginning of the business day tomorrow. No pressure.
I need to extract some data Table A (MS-Access), and reinsert it into a field in Table B. Thats the easy part. The hard part is that in order for the record to be complete, I also need to transfer some UUID-looking data from a Number field in Table A into another Number field in Table B, and for the life of me I can't figure out how to do this data-type conversion. In Table A, the data in the field (datatype is Number) looks like this in Access: {CF9F392F-04EB-4501-B5FC-57FE13C8503D}.
If I SELECT it in a query and do a CFDUMP, the data looks like this: 71-90-16-98-931122770-9691-26-111-897488-300000000000000000000
...but in the CFDUMP, its in a cell labelled as 'binary'.
If I try to select that field from Table A and directly insert it into Table B, I get this error message: "ByteArray objects cannot be converted to strings."
So my questions are, first, what type of data is this "Number"/Binary/UUID thing, and second, how can I insert it into another Number field in Table B?
Help!
David
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
