Skip to main content
Question

Read long binary data (blob) from Access database (.mdb) and write it to a shapefile

  • July 17, 2019
  • 1 reply
  • 235 views
L

I am using the MS_ACCESS_JDBC in FME Workbench to read an access database. One of the tables contains a "long binary data" field (blob) that I want to obtain the shape from. Then I try to write this field to a shapefile using the Esri Shapefile writer without success.

 

I have tried using the Geometry extractor testing all types of Geometry Encoding. But this doesn't provide me with any geometry.

 

Also, the reader specifies "oleobject" as type of this field (I can't change the field type from oleobject to blob)...not sure if this might be the problem.

 

Any help would be appreciated. Thanks!
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

david_r
Celebrity
  • david_rCelebrity
  • July 17, 2019

Could it be that the .mdb file is actually an ArcGIS Personal Geodatabase? If so, then you need to use that reader, not the Access reader.

Community Stats

32,207
Posts
122,303
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.