Thanks a bunch Dylan Leblanc. I got it. Its working fine. Here is the info. if some one is trying to do it.
For a "insert from textfile into table" to be successful, the data in the columns of your textfile must match the datatype of the column it will populate in MySQL. When using the "Insert data from a textfile into table" beware of "column head" rows in your textfile being imported. It's pretty straightforward. Hit the "Insert data from a textfile into table" link and simply follow the prompts on the page. By default, the field separator character is a ";" and change this to "," (comma separated values). I've never had any luck with the "replace" checkbox and turning "replace" on has never had an effect for me, maybe this will work in future releases. If you want to replace a table's data with new data from a .csv file, first empty the table then "insert data from a textfile".