Home » questions » Hi, I need to convert my datas on Microsoft Excel to My sql, how do I go about this?

Hi, I need to convert my datas on Microsoft Excel to My sql, how do I go about this?

2006-08-16 01:01:51, Category: Programming & Design
Hi, I need to convert my datas on Microsoft Excel to My sql, how do I go about this? I really want to use php and my sql around a site i am working on.

Answers

  1. riff_reef

    On 2006-08-16 01:15:49


    look for "MySQL Migration Tools" on the internet, there are lots of them for free downloads...
  2. Deepak Goel

    On 2006-08-16 01:50:56


    dude its pretty simple you can "navicat". look for it on www.navicat.com. Download and install it. It might be a trial version but can solve very quiclky to ur problem after installing just configure it to same port you installed mysql and then configure to the desired database. once u are done, you can import/export individual table to/from excel. also you can try exporting the whole database to .sql. you may also try to export the whole data into one sheet but i am not sure about this hope this will help u