CCTV Manager

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})
NameExplanationData Type
mdb

The input Access database.

File
Access Database

The input Access database.

File
access_tables

The tables to import into a file geodatabase.

String
Tables to Import

The tables to import into a file geodatabase.

String
out_folder_path

The folder location for the new file geodatabase.

Folder
File Geodatabase Location

The folder location for the new file geodatabase.

Folder
out_name

The name of the new file geodatabase.

String
File GDB Name

The name of the new file geodatabase.

String
import_type
(Optional)

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

String
Import Options

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

String
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