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
  • 193 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!

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.

Reply


Helpful Members This Week

Community Stats

31,370
Posts
118,975
Replies
39,000
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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.