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

Dialog

Label	Explanation	Data 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

Python

arcpy.utilsolutions.ImportAccessTables(mdb, access_tables, out_folder_path, out_name, {import_type})

Name	Explanation	Data 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