Copy Rows (Data Management)

Summary

Copies the rows of a table to a different table.

Usage

• The tool copies the rows of a table, table view, feature class, feature layer, delimited file, or raster with an attribute table to a new geodatabase or dBASE table or a delimited file.

• This tool supports the following table formats as input:

  • Geodatabase
  • dBASE (.dbf)
  • Microsoft Excel worksheets (.xls and .xlsx)
  • Memory-based tables
  • Delimited files
    • Comma-delimited files (.csv, .txt, and .asc)
    • Tab-delimited files (.tsv and .tab)
    • Pipe-delimited files (.psv)

  For delimited files, the first row of the input file is used as the field names on the output table. Field names cannot contain spaces or special characters (such as $ or *), and an error will occur if the first row of the input file contains spaces or special characters.

• The tool can be used to output a delimited file by adding one of the following file extensions to the output name in a folder workspace:

  • Comma-delimited files (.csv, .txt, or .asc)
  • Tab-delimited files (.tsv or .tab)
  • Pipe-delimited files (.psv)

• If the input is a table view or feature layer and has a selection, only the selected rows will be copied to the output table.

• All rows will be copied if the input is a feature class or table. If the input rows are from a layer or table view that has a selection, only the selected features or rows will be used.

• If the input rows are a feature class, only the attributes, not the geometry, will be copied to the output table.

• To add or append the copied rows to an existing table, use the Append tool.

Parameters

Dialog

Label	Explanation	Data Type
Input Rows	The input rows to be copied to a new table.	Table View; Raster Layer
Output Table	The table that will be created and to which rows from the input will be copied. If the output table is in a folder, include an extension such as .csv, .txt, or .dbf to make the table the specified format. If the output table is in a geodatabase, do not specify an extension.	Table
Configuration Keyword (Optional)	The default storage parameters for an enterprise geodatabase.	String

Python

arcpy.management.CopyRows(in_rows, out_table, {config_keyword})

Name	Explanation	Data Type
in_rows	The input rows to be copied to a new table.	Table View; Raster Layer
out_table	The table that will be created and to which rows from the input will be copied. If the output table is in a folder, include an extension such as .csv, .txt, or .dbf to make the table the specified format. If the output table is in a geodatabase, do not specify an extension.	Table
config_keyword (Optional)	The default storage parameters for an enterprise geodatabase.	String

Code sample

CopyRows example 1 (Python window)

The following Python window script demonstrates how to use the CopyRows function in immediate mode.

import arcpy
arcpy.env.workspace = "C:/data"
arcpy.management.CopyRows("vegtable.dbf", "C:/output/output.gdb/vegtable")

CopyRows example 2 (stand-alone script)

The following stand-alone script demonstrates how to use the CopyRows function to copy the tables in a folder to a file geodatabase.

# Description: Convert all dBASE tables in a folder to geodatabase tables
# Requirement: os module

# Import system modules
import arcpy
import os
 
# Set environment settings
arcpy.env.workspace = "C:/data"
 
# Set local variables
outWorkspace = "c:/output/output.gdb"
 
# Use ListTables to generate a list of dBASE tables in the
#  workspace shown above.
tableList = arcpy.ListTables()
 
# Run CopyRows for each input table
for dbaseTable in tableList:
    # Determine the new output feature class path and name
    outTable = os.path.join(outWorkspace, os.path.splitext(dbaseTable)[0])
    arcpy.management.CopyRows(dbaseTable, outTable)

Environments

Current Workspace, Output CONFIG Keyword, Maintain Attachments, Scratch Workspace, Extent, Preserve Global IDs