Select to view content in your preferred language

Access MDB > Extracted data to GDB > Geodatabase table to feature class?

341
2
02-18-2026 11:34 AM
Ed_
by MVP Regular Contributor
MVP Regular Contributor

So this is my first time extracting data from MS Access MDB database to an ArcGIS Pro 3.6 geodatabase. I used the Quick Import tool for this purposes. The conversion worked as in the data was extracted as geodatabase tables. However some of these geodatabase tables are actually vector data but Pro does not recognize them during the conversion and instead converts them as geodatabase tables. My question is how can I now convert this for example geodatabase table to a line feature class. It's attributes are as follows

Ed__0-1771443219779.png

 

SHAPE has data type Text

SHAPE_Length and SHAPE_Area have data type Double

Question | Analyze | Visualize
2 Replies
BruceHarold
Esri Frequent Contributor

Ed, make sure to use the Esri Geodatabase (Personal Geodb) format in Quick Import, not Microsoft Access.

See also:  https://docs.safe.com/fme/2025.1/html/FME-Form-Documentation/FME-ReadersWriters/personal_geodatabase...

 

RenatoSalvaleon3
Esri Contributor

Recently, I have to help a customer use the same Quick Import tool with two decades of PGDBs to convert and in one geodatabase, the GP tool returned an error message, out of bound coordinates in one feature class. 

If you come across other issues that prevent you from moving forward with Quick Import, you can also use the Workbench app as a standalone to build that workspace. If you have to repeat the conversion multiple times, you get more flexibility out of the workbench app for potential errors like, projection issues, bad data, renaming attributes, etc.

When using the Workbench app, use the Generate Workspace tool to start that workflow. 

RenatoSalvaleon3_0-1771521982029.png