Appending help needed!!

by 3 replies
4
I need to append my excel sheet to my existing mysql table with data. Can someone guide me here and explain the code as to how i should do it. I am getting a syntax error when i do this.
#programming #appending #needed
  • I've never done that yet although may be doing so soon. If you have phpMyAdmin I think you can just import the excel file there and it should create and populate the table in the DB?!?
    • [1] reply
    • HI

      You can append your excel sheet to existing mysql data using php langauage with mysql database.It will be easy for you to move.
  • In the excel sheet, are the columns setup the same as the sql table?

    If yes, save te excel as a CSV, and import the csv using PHPMyAdmin directly into the table.

    If the columns aren't the same, the easiest thing to do would be to make it the same and then follow the above.
Join the discussion

Next Topics on Trending Feed

  • 4

    Appending help needed!!

    I need to append my excel sheet to my existing mysql table with data. Can someone guide me here and explain the code as to how i should do it. I am getting a syntax error when i do this.