Skip to main content
Question

Problems with SQL Statement and Access

  • February 20, 2020
  • 2 replies
  • 14 views

Forum|alt.badge.img

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?

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.

2 replies

redgeographics
Celebrity
Forum|alt.badge.img+59
  • Celebrity
  • 3700 replies
  • February 20, 2020

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


Forum|alt.badge.img+2
  • 1891 replies
  • February 20, 2020

@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.