Importing CSV file into MySQL

[login365]

Im currently trying to import a CSV file into a MySQL database using myPHPAdmin 2.6.2, using the "Insert data from a text file into the table".

However when I do this, all the values in each of the cell has a large amount of spaces included. I have tried all the different configurations of importing the CSV data, but without success.

Can anyone help?

TIA, Mike

[devinemke]

are those spaces in the CSV? if they are then obviously they will be in the db as well after the import.

[login365]

No they are not in the CSV file.

When I open a record and then close it, all the white space goes.

Mike