472,127 Members | 1,471 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,127 software developers and data experts.

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

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
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
Jan 6 '07 #1
2 1968
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
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

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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.