CSV in model builder

3855
4
03-21-2014 06:15 AM
KyleHahn
New Contributor
Good morning,

Just having some issues and thought I would ask for some help. What do you all recommend for getting a .csv file into a "more useable" format? I have a file with roughly 10,000 records. Just need it for some simple selection or querying within model builder and I can't seem to find the tool or combination of tools to help get the file into an easy to use format. the table doesn't contain any spatial data I should add.
any help is greatly appreciated.

Thanks.
0 Kudos
4 Replies
DuncanHornby
MVP Notable Contributor
Kyle,

Use the Table to Table tool to convert your CSV to a File GeoDatabase Table.

Duncan
0 Kudos
KyleHahn
New Contributor
Yeah that's actually what my first step was and it keeps returning an empty output.
0 Kudos
KyleHahn
New Contributor
Ok my issue I believe is I didn't have an objectId in the table. now is there a way to add that into the existing csv in modelbuilder?

thanks for the help.
0 Kudos
DuncanHornby
MVP Notable Contributor
By running the Table to Table tool and storing the output table in a File GeoDatabase you will automatically get an OBJECTID field as all tables must has one in a GeoDatabase.

If you are getting empty output then this should suggest your CSV is corrupt in some way, such as blank rows, invalid syntax etc.
0 Kudos