www.webdeveloper.com
Results 1 to 2 of 2

Thread: Import the data from excel file

  1. #1
    Join Date
    Mar 2011
    Posts
    20

    Import the data from excel file

    Hello sir,
    I want to import all the data of a excel file to import in the database (PHPMyAdmin) table of of format id, name, reg_no, Roll_No, sub1, sub2, sub3, sub4, sub5, sub6, sub7, sub8, sub9, sub10, sub11, sub12, sub13, sub14, sub15, sub16 and remarks
    These are the heading of that table, i have all the record of respective table. How i m able to import such data.

    Thankx

  2. #2
    Join Date
    Sep 2009
    Posts
    163
    If your database structure is same then you can directly import data from excel file to MySQL. You just need to click on Import tab and many options are present there.

    But if you need changes in that then you have to write a script for that.
    Visit - http://www.webdevelopmentservices.ca/ for web design and development services

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles