#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2013
    Location
    Lahore, Pakistan
    Posts
    7
    Rep Power
    0

    How to import Excel file in Database? mysql or any other


    Hello,


    Dear friends, I really need help in this task, my supervisor has given me a task to import an excel file in Java/C++ or any other language and link it to some database. I think the more simple one he said, import any excel file in database, that can be mysql database.

    I am not a good programmer so its difficult for me, Need help.


    Regards

    Furqan Arshad
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,118
    Rep Power
    4274
    in mysql, use the LOAD DATA INFILE command

    it is explained in da manual
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2013
    Location
    Lahore, Pakistan
    Posts
    7
    Rep Power
    0
    I was looking for some detailed answer, I discussed with my supervisor again, and he is saying do it as its a check tast and simple one. I don't have good background of programming. So I need some explained reply if you can.

    and where is the manual you just said ?


    Regards
  6. #4
  7. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2012
    Location
    Iran
    Posts
    149
    Rep Power
    139
    Originally Posted by furki
    I was looking for some detailed answer,
    MySQL has a very detailed manual with examples, all you need to do is just read the manual related to LOAD DATA as Rudy indicated.

    Originally Posted by furki
    and where is the manual you just said ?
    If you google for it, it is the first link that comes up

    http://dev.mysql.com/doc/refman/5.0/en/load-data.html


    Regards,
    Dariyoosh
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2013
    Location
    Lahore, Pakistan
    Posts
    7
    Rep Power
    0
    Thanks both of you. I am checking manuals, those you said, I hope it would help in my problem.


IMN logo majestic logo threadwatch logo seochat tools logo