I'm trying to import data from a CSV file to an existing MySQL database. I am unable to do this successfully. I get various errors. The best I have been able to do it import the correct number of rows but all zeros in the first column and the rest of the columns are full of nulls. I think the problem is with the Control Characters settings in the Heidi import tool. I tried replacing the TAB characters separating the data items in the CSV file with commas but no joy. First two lines of CSV file are:
Thanks for any help.