nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

arcpy.TableToTable_conversion CSV to DBF help

DannyLackey

Using this page as my resource: ArcGIS Help (10.2, 10.2.1, and 10.2.2)

I came up with this:

import arcpy from arcpy import env env.workspace = "C:\" inTable = "c:\test.csv" outLocation = "c:\test.dbf" outTable = "test" arcpy.TableToTable_conversion(inTable, outLocation, outTable)

However, it's failing:

Traceback (most recent call last):

File "c:\test.py", line 4, in <module>

arcpy.TableToTable_conversion("c:\test.csv", "c:\test.dbf", "test")

File "C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy\arcpy\conversion.py", line 1904, in TableToTable

raise e

ExecuteError: Failed to execute. Parameters are not valid.

ERROR 000732: Input Rows: Dataset c:\test.csv does not exist or is not supported

ERROR 000732: Output Location: Dataset c:\test.dbf does not exist or is not supported

Failed to execute (TableToTable).

Is it clear where I'm going wrong?

Find more posts tagged with

Accepted answers

DarrenWiens2

Your paths are wrong, for Python. '\t' happens to mean tab. You can get around it by always prefacing paths with an 'r' to denote raw string format.

For example:

<SPAN class="n" style="font-weight: inherit; font-style: inherit; font-family: inherit;">inTable</SPAN> <SPAN class="o" style="font-weight: inherit; font-style: inherit; font-family: inherit;">=</SPAN> r<SPAN class="s" style="font-weight: inherit; font-style: inherit; font-family: inherit;">"c:\test.csv"</SPAN>

All comments

DannyLackey

This is related to the same effort, but specifically to the output... If need to start a new post, let me know...

In the resulting .dbf file, its creating a decimal with trailing zeroes:

750050

becomes

750050.00000000000

How can I avoid this?

DanPatterson_Retired

The debate .... the options ....

Filenames and file paths in Python

Luke_Pinner

I tend to use r'' as well. Except when it doesn't work.

DarrenWiens2

Yes, but double backslashes are more typing. As Luke points out, you can also use forward slash, but then you need to remember whether it's forward or backslashes you can't use. It's personal preference, but I use 'r'.

AdrianWelsh

I was going to mention that too! You beat me to it!

Luke_Pinner

Adrian Welsh wrote:

Can't you also use double backslash in place of the regular backslash in order to make the path correct?

inTable = "c:\\test.csv"

inTable = "c:\\test.csv"

Yes. And forward slashes work as well:

inTable = "c:/test.csv"

AdrianWelsh

Can't you also use double backslash in place of the regular backslash in order to make the path correct?

inTable = "c:\\test.csv"

DannyLackey

Thank you. I got it working. I had a few things wrong.

Here is my new WORKING code:

import arcpy
from arcpy import env

env.workspace = r"C:\test"

inTable = r"C:\test\test.csv"
outLocation = r"C:\test\output"
outTable = "test.dbf"

arcpy.TableToTable_conversion(inTable, outLocation, outTable)

DarrenWiens2

Your paths are wrong, for Python. '\t' happens to mean tab. You can get around it by always prefacing paths with an 'r' to denote raw string format.

For example:

<SPAN class="n" style="font-weight: inherit; font-style: inherit; font-family: inherit;">inTable</SPAN> <SPAN class="o" style="font-weight: inherit; font-style: inherit; font-family: inherit;">=</SPAN> r<SPAN class="s" style="font-weight: inherit; font-style: inherit; font-family: inherit;">"c:\test.csv"</SPAN>

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.