Question

Problems with SQL Statement and Access

  • 20 February 2020
  • 2 replies
  • 2 views

Badge

I have a lot of shapefiles that I want to clip with different areas which I read from MSAcces and I want to select the area that I need for the certain shapfile and clip the shape-file. I use SQL Executor connected to a MS Access database to select the area that I want to use but I don't get the area. Do anyone have any solution?


2 replies

Userlevel 5
Badge +25

How are the areas stored in Access and how have you set up the SQLExecutor?

Badge +2

@ann Is your MS Access file an Esri Personal Geodatabase? If it is then you can use the FME Geodatabase (MDB) reader. To do that you need a 32bit version of FME installed along with ArcGIS.

Reply