Question

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

  • 17 July 2019
  • 1 reply
  • 49 views

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

Userlevel 4

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