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

Kemahiran: .NET, Pemasukan Data, Pemprosesan Data, PHP, Visual Basic

Lihat lagi: 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

Tentang Majikan:
( 13 ulasan ) Kowloon, Hong Kong

ID Projek: #88437

7 pekerja bebas membida secara purata $54 untuk pekerjaan ini


I will do it for you.

$50 USD dalam 0 hari
(296 Ulasan)

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 dalam sehari
(63 Ulasan)

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

$30 USD dalam sehari
(9 Ulasan)

ready to do..

$80 USD dalam 2 hari
(2 Ulasan)

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

$80 USD dalam sehari
(0 Ulasan)

All will be perfect.

$60 USD dalam sehari
(0 Ulasan)

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 dalam sehari
(0 Ulasan)