Data Conversion from Binary Format to Base 64

Mike2015
Mike2015 used Ask the Experts™
on
I have attachment files, of various types, which have been converted to binary format and stored within my SQL Server database table.

I need to convert the binary file data to Base 64. Does anyone have a coding module written in VBA which can accomplish this?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
There is code floating around all over to do this i.e.:

https://thydzik.com/vb6vba-functions-to-convert-binary-string-to-base64-string/

But it will require you to use some type external lib.   If performance is a factor, or your doing something with encryption, you may want to look into a 3rd party product.

Jim.

Author

Commented:
Thank you for your response. This was definitely helpful.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial