By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,622 Members | 2,072 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,622 IT Pros & Developers. It's quick & easy.

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

seshu
100+
P: 156
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
Share this Question
Share on Google+
2 Replies


ronverdonk
Expert 2.5K+
P: 4,258
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

P: 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.