Skip to main content
Question

Problems with SQL Statement and Access


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?

2 replies

redgeographics
Celebrity
Forum|alt.badge.img+50

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


Forum|alt.badge.img+2
  • 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.


Reply


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