Avatar of EMCIT
EMCIT
 asked on

Convert Binary Data to PDF

Good day all,

I have a field in a SQL table that contains binary data that I need to convert to a PDF. All recommendations are appreciated.
Microsoft AccessVB Script

Avatar of undefined
Last Comment
Bill Prew

8/22/2022 - Mon
Guy Hengel [angelIII / a3]

and what is that binary data?
and do you plan to "display" the data/pdf?
EMCIT

ASKER
The binary is a converted PDF.  I need to convert it back to pdf to save as a .pdf.
Bill Prew

What is the data type of the field that the binary data (PDF data) is stored in?

~bp
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
EMCIT

ASKER
The field is varbinary(MAX)
Bill Prew

Okay, what do you have so far?  Are you working in Access using VBA, or in VBScript?  Can you share the code you have that connects to the data base and does a query, etc?

~bp
EMCIT

ASKER
I'm building an Access front end (VB) that will connect to SQL via ODBC. A variable will be passed that will identify the record to be retrieved. The PDF (Binary) will be saved to a network location.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
Bill Prew

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question