Am sorry.
You guys are right. As frederico_fonseca said the data is...

No Jeff the file is comma delimited only.

There is comma also in few fiends Jeff but it did not cause me any issues.
Below are some wierd data in some of the columns:
NORTH DAKOTA STATE A"...

Thank you all for the help.
This is how I was able to resolve the issue.
I did set the TextQualified to False on the columns where the issue...

Jeff,
This is public data which i got from website so I think i can share.
Below is 2 more records.

Thank you Guru for the quick reply.
I am attaching the sample data here.
To answer your question, this is not consistent.