Unanswered: Converting Base64 to Binary when transforming SQL to Access
I am trying to transform an SQL database to a Microsoft Access database, however my original database has base64 text strings stored in it, which are longer than the limit for an Access memo. Consequently, the transformation wizard shortens the strings when it transforms the database. To get around this, I was hoping to be able to convert the base64 strings back to binary and store them as OLE Objects in the Access database. Does anyone know an easy way (or even a hard way) to do this? Or is there another way to get around the problem?