Link to home
Start Free TrialLog in
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.
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

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

ASKER

The binary is a converted PDF.  I need to convert it back to pdf to save as a .pdf.
What is the data type of the field that the binary data (PDF data) is stored in?

~bp
Avatar of EMCIT

ASKER

The field is varbinary(MAX)
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
Avatar of 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.
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial