how to load data from text file is posible even from excell sheet

[seshu]

hi every body
This is seshu i have doubt in mysql i have some date in excell sheet to export that data i have copied all the data into a text file and the wrote this code in mysql editor
LOAD DATA LOCAL INFILE 'pet.txt' INTO TABLE pet;
it has been exported but now the problem is insted giveing my id no as id_0033
it is giving Id_0033along with a box suffixed to the id and this is only to last coumn why is it showing so is it because of the space there in text file after every row
apart from this is there any way to the data in excell to my sql table
Thanking you sir
Regards
seshu

[ronverdonk]

In order to help further, show us part (some rows) of your pet.txt file and the column defs of your table into which it will be loaded.

Ronald :cool:

[tshot]

This seems more of dos to unix kind if problem i.e DOS places both a line feed and a carriage return character at the end of each line of a text file, but Unix uses only a line feed character.
So the CR character (^M i.e ascii 13) must be appearing as box

regds
tshot