Closed

Solution to import Subscript and Superscript from an excel file to mySQL Database?

We have a lot of chemistry MCQs in an excel file with lot of chemistry formulas and equations. When we tried to import these MCQs into mySQL based database all subscripts used in formulas lost and taken as normal character e.g, H2SO4, CO2, CH3 etc and makes our formulas and elements name nonsense. We need any solution by which mySQL can import subscript and superscript as it is from excel Or any solution by which we can force excel to consider subscript and superscript as inserted symbols because mySQL can pick symbols as it is.

Our exam application made by PHP and mySQL and we need permanent solution for it e.g, method, utility etc. A sample file with chemistry formula with sub and super script is attached.

Skills: Database Programming, MySQL, PHP, Software Architecture, SQL

See more: import excel file mysql using vbnet, reading excel file mysql database java, import excel file mysql database php, import sql file mysql database, import excel file mysql export using php, upload excel file mysql database php, convert excel file mysql database, import excel file mysql using java, code bulk upload excel file mysql database php, import excel file access database vba, import excel file mysql php, insert excel data mysql database table file jsp hibernate, php import excel file mysql smarty, php tutorial import excel file mysql, upload excel file mysql database asterisk, import excel file mysql database using php, insert data excel file mysql database using jsp, upload excel file mysql database using php, insert excel file mysql database using jsp

About the Employer:
( 0 reviews ) Lahore, Pakistan

Project ID: #18992568

6 freelancers are bidding on average $77 for this job

pbelhe9

Hello. How are you? Thanks for your posting. I read your detail description and I understood what you need. As an web expert. i have strong skills and experiences in web development for 7 years. I am a expert web More

$35 USD in 10 days
(45 Reviews)
6.6
kipdev13

Nice to meet you. I've read the project description and definitely can develop this. I'll provide you with the highly skilled & professional HTML/CSS, PHP/WordPress/CodeIgniter, JavaScript, MySQL, front & back-end we More

$35 USD in 10 days
(81 Reviews)
6.4
anshulikabansal

Hello Sir, I have understood your issue to capture superscript or subscript so that Formulas would not look like nonsense. I can develop such import script from CSV to MYSQL for you. So it will not kill the look More

$100 USD in 1 day
(77 Reviews)
5.7
kanwalrafique

Hi, I read your project brief. I'd like to help you but I can't because the PHP libraries which are available for reading Excel files have severe limitations. So I'm bidding on this project just to inform you about the More

$35 USD in 10 days
(34 Reviews)
5.4
finaldragon123

Hello sir. Already, I checked the description more carefully. So I'd really like to work with you on this one if possible! My name is Maxim and I am a web developer with nearly 9 years of experience. I am a freelan More

$200 USD in 10 days
(6 Reviews)
3.5
abhimadankr

I read job description and I can do your project.I can even work on urgent basis and complete your project soon..contact me for more information

$55 USD in 2 days
(0 Reviews)
0.0