So I just got a Excel spreadsheet that had a bunch of TRUE/FALSE values spread through various columns. I opened this Excel spreadsheet with MS Access, in preparation exporting it to Oracle.
When I tried to export this spreadsheet to my Oracle database via the Export via ODBC() option in ACCESS, I would get a strange TRANSLATION PROTOCOL ERROR.
I checked in my MS ACCESS Design View, and saw that these columns were of datatype YES/NO (I had never seen this datatype before, so I suspected this was the culprit of the TRANSLATION PROTOCOL ERROR).
I tried numerous times to force the YES/NO datatype to become TEXT by changing the first few values from FALSE to FAWLSE, NO, etc and nothing really worked until I did a wholesale search and replace of every TRUE to 'HELL YES' and every FALSE to 'HELL NO' within Excel. Once I did that, I opened the spreadsheet in ACCESS, and exported to my Oracle database with no problems.
Now for some updates to set the values back.... argh
No comments:
Post a Comment