I need to read a table located in a Ms Access database and process it with layers.
What is the best way to transfer or copy a MS Access table into a FGDB using python or arcpy?
Which flavor of Access? ArcMap or Pro?
ArcMap, set up an ODBC connection
I don't believe accdb or mdb are supported in ArcGIS Pro.
You could use pyodbc but look out for the 32/64 bit issue:
ArcGIS "ArcMap" 10.7 can read .mdb directly (though they don't recommend doing this, see the support article I posted). ArcMap is 32-bit so that solves some of the hassle. But accdb you need to set up an odbc connection. I would do what works, what works best may depend on your database format, the data involved, how often you need to do this, etc.
I think I'd got the route of using python to extract the access tables to a csv and then to a table to table with arcpy. see https://datatofish.com/how-to-connect-python-to-ms-access-database-using-pyodbc/ for pyodbc and https://stackoverflow.com/questions/37289951/how-to-write-to-a-csv-line-by-line/37290105#37290105 to write to a csv...
What about arcpy.utilsol.ImportAccessTables?
In ArcGIS 10.7 with Python 2.7 I am getting the following error message:
AttributeError: 'module' object has no attribute 'utilsol'
"utilsol" seems to indicate this may be part of a "solutions" add-on you don't have installed.
I would point back to the Esri support article which was updated earlier this year so I bet it has good guidance: