I created a new environment in Conda and installed Python 3.6.9 along with certain modules including ArcPy in that new environment. 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? Now, when the script in Spyder tries to import arcpy, I get the following error:
File, line , <module> arcgisscripting ImportError: DLL load failed: The specified procedure could be found.