Exporting Long Binary Data Fields from MS Access

Posted on 2007-09-28
Last Modified: 2013-11-30
We have used an old photo archiving program, Image Access Pro, to record our extensive photo collection.  The company making the program sold out 5 or 6 years ago, and so is unsupported.  We are trying to convert the database - an MS Access database - to another program, Extensis Portfolio.  Most of the fields in the old database are stored in a standard MS Access table, and we have transferred those to the new program with no problem.  However, the Description field is stored as "long binary data", and I can't figure out how to export that field.  I know the data is stored as long binary data strings somewhere, but I don't know where, and i have found no way of accessing them.  I have downloaded and installed "Ezy Exporter Premium" add-in for Access but it doesn't access the long binary data fields.

As you can see, I am no expert in MS Access or in SQL.  Is there any simple way I can export these long binary data fields to a text file?

Keith Holdeman
Question by:klhold
    LVL 3

    Accepted Solution

    This site describes how to do it:

    and the parent page is very informative background.
    LVL 44

    Assisted Solution

    by:Leigh Purvis
    It depends on your definition of Export.
    You're moving the data to another db platform (is it SQL Server yeah?)

    While using image files as an intermediatary is a possibility - I'd think of it as a fallback position personally.
    If possible - try to keep this all in memory.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now