Import Access Tables (Utility Solutions)

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.

Parameters

LabelExplanationData Type
Access Database

The input Access database.

File
Tables to Import

The tables to import into a file geodatabase.

String
File Geodatabase Location

The folder location for the new file geodatabase.

Folder
File GDB Name

The name of the new file geodatabase.

String
Import Options
(Optional)

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

String

arcpy.utilsolutions.ImportAccessTables(mdb, access_tables, out_folder_path, out_name, {import_type})
NameExplanationData 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