We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

How do I input/output an attachment data type in Access 2007 to an Oracle data type in 10g?

kkusic1
kkusic1 asked
on
Medium Priority
657 Views
Last Modified: 2012-05-11
I am in the process of migrating an Access 2007 database to an Oracle 10g database and ran into an issue with one of the field conversions.

In Access I have some Attachment fields that hold Microsoft word .docx files. I used SQL Developer to do the migration and it suggested using the Blob datatype in Oracle 10g. Access crashes when trying to retrieve the Blob because it does not know how to see this type. What would some code be for converting the attachment to a blob and converting the blob back into an attachment. I have found nothing online for this. It is key that the Word documents are held in this database.
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
CERTIFIED EXPERT
Most Valuable Expert 2014
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.