Utility Solutions Tools

Import Access Tables

Summary

Converts tables in an Access database to a file geodatabase for use in ArcGIS Pro.

Usage

  • This tool requires a 64-bit version of Microsoft Access Database Engine 2010 Redistributable be installed.
  • If CCTV inspection data exists in a file geodatabase, this tool is not necessary.

Syntax

arcpy.NOALIAS.ImportAccessTables(mdb, access_tables, out_folder_path, out_name, {import_type})
ParameterExplanationData Type
mdb

The input Access database.

File
access_tables

The tables to import into a file geodatabase.

String
out_folder_path

The folder location for the new file geodatabase.

Folder
out_name

The name of the new file geodatabase.

String
import_type
(Optional)

Provides an option for importing data and schema, or schema only.

String

Code sample

ImportAccessTables example (python window)

Converts tables in an Access database to a file geodatabase.

arcpy.utilsol.ImportAccessTables("D:/data/PACPSample.mdb", 'Conditions;Inspections', "D:/data", "PACPSample_converted", "DATA")
ImportAccessTables example (stand-alone script)

Converts tables in an Access database to a file geodatabase.

# Name: ImportAccessTables.py
# Description: Converts tables in an Access database to file geodatabase.

# Import required modules
import arcpy

# Local Variables
database = "D:/data/PACPSample.mdb"
tables = ['Conditions', 'Inspections']
folder = "D:/data"
name = "PACPSample_converted"
import_type = "DATA"

arcpy.utilsol.ImportAccessTables(database,
                                 tables,
                                 folder,
                                 name,
                                 import_type)

Environments

This tool does not use any geoprocessing environments.

Licensing information

  • Basic: No
  • Standard: Yes
  • Advanced: Yes
Top