CSV in model builder

[KyleHahn]

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.

[DuncanHornby]

Kyle,

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

Duncan

[KyleHahn]

Yeah that's actually what my first step was and it keeps returning an empty output.

[KyleHahn]

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.

[DuncanHornby]

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.