I'm trying to convert an Excel file to a DBF file. I understand how to do it correctly using the Table to Table tool. However I am having an issue where a column of repeating numbers (labeled ZoneNum) are converted into nothing but zeroes. There doesn't seem to be any other issues with the other columns such as street names, ID number, work done, etc. I believe it has to do with the repeating numbers. For example 16 streets might be under ZoneNum 1 so their attribute would be 1. The next 7 streets might be under ZoneNum 3. I've tried to store the number as text instead but then nothing showed up. I've formatted each column as numbers or text. I've tried converting to a csv file instead to then convert to DBF file with no results. Please help!
Here's 3 sample lines from my file (minus the linebreaks):
104,14,Yosemite Drive,Everglade Circle,South End,Cape Seal 105,14,Zion Avenue,Jefferson Street,Carlsbad Street,Slurry Seal 106,17,Aberdeen Drive,Venice Avenue,West End,"1.5"" Edge Grind & Overlay"