469,610 Members | 1,554 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,610 developers. It's quick & easy.

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

seshu
156 100+
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
Jan 6 '07 #1
2 1867
ronverdonk
4,258 Expert 4TB
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:
Jan 6 '07 #2
tshot
1
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
Jan 7 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

9 posts views Thread by Ksenia Marasanova | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.