Page 1 of 1

Need help importing to mysql ( language problem )

Posted: Fri Oct 10, 2008 8:20 am
by wpsd
Here is my problem
I have a ton of data in excel way and i want to import it to my database ( using phpmysql )
since phpmysql cant import excel i change it to csv but unable to import cause... i dont know what the cause is

so i use second method excel to access than convert it to text base a .txt file
and i use some simple code that read ( fopen ) from the .txt file and do an insert loop

the data that i need to import has number, text and chinese text
the chinese text never show up correctly neither in phpmysql nor in the web ( but it show ok in the array when insert looping )

can anybody help me i'm stuck now

my database and all the table use utf8_general_ci
than i set in my small php :
mysql_query("SET_NAME UTF8")... something like this im positive i write it correct in the php
than use some php mb extension to set to utf8 also
but no luck at all

if i use a form an input box it than submit it will show nicely in the database and web ( 1000 more data i dont think so :( )

Re: Need help importing to mysql ( language problem )

Posted: Sun Oct 12, 2008 3:59 am
by pavanpuligandla
@ above..

why converting ur excel spreadsheet to another format like .csv?
dun ever do like that.
import excel itself to the database.
i wolud like to hear more frm u. so tht i can help u out..