Annulleret

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

Færdigheder: .NET, Dataindførsel, Databehandling, PHP, Visual Basic

Se mere: insert chinese mysql, excel chinese utf8, insert chinese database excel, insert utf data mysql, insert utf8, excel chinese mysql, excel mysql support utf, quick text, mysql db, insert chinese data mysql, excel macro chinese utf, mysql insert utf8 data, mysql chinese data, php db, excel visual basic, data visual, data encoding, Chinese, excel database visual basic, quick excel, convert mysql encoding utf, insert macro excel, php support mysql, macro script file, excel file mysql

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

Projekt-ID: #88437

7 freelancere byder i gennemsnit $54 for dette job

nanolab

I will do it for you.

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

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)
6.7
easternstarlinz

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 Mere

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

ready to do..

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

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)
0.0
belovedwik

All will be perfect.

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

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)
0.0