topic Re: arcpy.TableToTable_conversion CSV to DBF help in Python Questions

arcpy.TableToTable_conversion CSV to DBF help

DannyLackey — Wed, 03 Feb 2016 21:19:46 GMT

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?

Re: arcpy.TableToTable_conversion CSV to DBF help

DarrenWiens2 — Wed, 03 Feb 2016 21:23:38 GMT

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:

inTable = r"c:\test.csv"

Re: arcpy.TableToTable_conversion CSV to DBF help

DannyLackey — Wed, 03 Feb 2016 21:37:26 GMT

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)

Re: arcpy.TableToTable_conversion CSV to DBF help

AdrianWelsh — Wed, 03 Feb 2016 21:38:10 GMT

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

inTable = "c:\\test.csv"

Re: arcpy.TableToTable_conversion CSV to DBF help

Luke_Pinner — Sun, 12 Dec 2021 02:48:30 GMT

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"

Re: arcpy.TableToTable_conversion CSV to DBF help

AdrianWelsh — Wed, 03 Feb 2016 21:43:47 GMT

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

Re: arcpy.TableToTable_conversion CSV to DBF help

DarrenWiens2 — Wed, 03 Feb 2016 21:52:23 GMT

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'.

Re: arcpy.TableToTable_conversion CSV to DBF help

Luke_Pinner — Wed, 03 Feb 2016 22:18:29 GMT

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

Re: arcpy.TableToTable_conversion CSV to DBF help

DarrenWiens2 — Wed, 03 Feb 2016 22:28:35 GMT

Good to know. I can't say I've ever run into that situation (e.g. r'\'), but the lengthy and pointed discussion certainly makes me think it comes up more often than my brief experience.

Re: arcpy.TableToTable_conversion CSV to DBF help

Luke_Pinner — Wed, 03 Feb 2016 23:09:39 GMT

It's not just r'\', but any trailing backslash, i.e r'C:\'

Re: arcpy.TableToTable_conversion CSV to DBF help

DanPatterson_Retired — Wed, 03 Feb 2016 23:33:53 GMT

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

Filenames and file paths in Python

Re: arcpy.TableToTable_conversion CSV to DBF help

AdrianWelsh — Thu, 04 Feb 2016 14:08:58 GMT

Thanks for mentioning where "r\" doesn't work. Python is a lot deeper than I once thought! (and a deal more complicated)

Re: arcpy.TableToTable_conversion CSV to DBF help

DannyLackey — Thu, 04 Feb 2016 18:23:59 GMT

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?