Geoprocessing tool reference > Conversion toolbox > To dBASE toolset > Tools
Table to dBASE (multiple) (Conversion) |
|
|
Release 9.2
Last modified April 2, 2008 |
Print all topics in : "Tools" |
Converts one or more tables to dBASE tables. The inputs can be dBASE, INFO, geodatabase, or OLE DB tables.
Usage tips
-
The name of the output tables will be based on the name of the input table. For example, if the input is c:\gdb.mdb\Gondor, the output dBASE table will be named gondor.dbf. To explicitly control the output name and for some additional conversion options, use the Table To Table tool.
-
The Copy Rows and Table To Table can also be used to convert a table to a dBASE file.
-
If the name of the output table already exists in the output folder, a number will be appended to the end to make it unique (for example, OutputTab_1.dbf).
Command line syntax
An overview of the Command Line window
TableToDBASE_conversion <Input_Table;Input_Table...> <Output_Folder>
| Parameter | Explanation | Data Type |
| <Input_Table;Input_Table...> |
The list of tables to be converted to dBASE. These can be INFO, geodatabase, OLE DB, or dBASE tables. It can also be a table view (a table in the ArcMap table of contents [TOC] or the result of running MakeTableView tool); if this is the case, only selected records will be in the output. |
Table View |
| <Output_Folder> |
The output or destination folder. |
Folder |
Command line example
TableTodBASE "c:\data\mydbase.dbf;c:\data\myinfo.dat;c:\mygdb.mdb\tab1" c:\myFolder
Scripting syntax
About getting started with writing geoprocessing scripts
TableToDBASE_conversion (Input_Table, Output_Folder)
| Parameter | Explanation | Data Type |
| Input_Table (Required) |
The list of tables to be converted to dBASE. These can be INFO, geodatabase, OLE DB, or dBASE tables. It can also be a table view (a table in the ArcMap table of contents [TOC] or the result of running MakeTableView tool); if this is the case, only selected records will be in the output. |
Table View |
| Output_Folder (Required) |
The output or destination folder. |
Folder |
Data types for geoprocessing tool parameters
Script example
# ConvertTodBASEExample.py
# Description: Simple example showing a use of the TableTodBASE
# Requirements: Python and the Python win32all extension
# Author: ESRI
# Data 1/6/2004
# Create the Geoprocessor
import arcgisscripting
gp = arcgisscripting.create()
# Put in error trapping in case an error occurs when running tool
try:
# Set the workspace, then export list of SDE table
gp.Workspace = "Database Connections/Connection to Doosie.sde"
gp.FeatureClassToShapefile("ED.Owners ; ED.StoresInfo ; ED.Sales","c:/geodata/tables")
except:
# If an error occurred print the message to the screen
print gp.GetMessages()