I created a new environment in Conda and installed Python 3.6.9 along with certain modules including ArcPy in that new environment. Now, when the script in Spyder tries to import arcpy, I get the following error:
File "~\Local\Programs\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 14, in <module> import arcgisscripting ImportError: DLL load failed: The specified procedure could not be found.
Please note that I don't use ArcGIS Pro, I only installed the latest ArcPy so that I can use it in a particular Conda environment. I use ArcGIS, but I don't use its ArcPy because it's limited to Python 2.7. How can I resolve this issue?