Quick script to insert Chinese UTF8 data from Excel to mySQL DB

Small script needed to input Chinese data (UTF-8) from excel sheet into mysql5.0 database(UTF-8). Please refer to the attached excel sheet as example.

New mysql server just installed, supports utf8 encoding.

New php version, also support utf8.

I have tried many methods but it seems that I cannot convert the chinese text into UTF-8 encoding properly so that I can input in mysql database.

I have tried using C# via JET OLEDB4.0 to input into mysql.

I have also tried outputting in txt format and using php to parse the text file and input into mysql.

The finished program can be in Visual Basic, C#, PHP, Excel Macro. However, the finished result MUST BE GOOD UTF-8 ENCODING data inserted into mysql database WITHOUT any information loss.

Please contact for further information.

Thank you

Evner: .NET, Dataindførsel, Databehandling, PHP, Visual Basic

Se mere: insert chinese mysql, excel mysql utf8 data macro, convert chinese data database excel, excel chinese utf8, insert chinese database excel, mysql insert convert using chinese, insert utf data mysql, insert utf8, excel chinese mysql, excel mysql support utf, quick text, mysql db, convert chinese excel utf8 php, insert chinese data mysql, excel macro chinese utf, mysql insert utf8 data, mysql chinese data, excel macro utf encode chinese, chinese chinese, Visual Basic Excel, php db, excel visual basic, database script, data visual, data encoding

Om arbejdsgiveren:
( 13 bedømmelser ) Kowloon, Hong Kong

Projekt ID: #88437

7 freelancere byder i gennemsnit $54 på dette job


I will do it for you.

$50 USD in 0 dage
(296 bedømmelser)

I am chinese live in Hong Kong and I always write such programs. See the screen capture in the PM and you can see your requirement was fullfilled!! pls PM me for further discussion

$50 USD på 1 dag
(63 bedømmelser)

Please try to convert the xls into Ms Sql Server,then use the Mysql Migration tool to convert Sqlserver into [url removed, login to view] any question,PM [url removed, login to view] doesn't need any [url removed, login to view]'s enough to use exist tools. Btw ,I am also a Ch Flere

$30 USD på 1 dag
(9 bedømmelser)

ready to do..

$80 USD in 2 dage
(2 bedømmelser)

I have working experiece on Excel programming, and I am a Chinese, I will finish the project very well.

$80 USD på 1 dag
(0 bedømmelser)

All will be perfect.

$60 USD på 1 dag
(0 bedømmelser)

hi, we are a group of Chinese professionals. We can handle your requirements with solution that is easy to operate and independent of your working environment. Please check PMB.

$30 USD på 1 dag
(0 bedømmelser)