Appending help needed!!

3 replies
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.
#appending #needed
  • Profile picture of the author AndyBlackSEO
    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?!?
    Signature
    [FREE SEO TOOL] Build 29 Effective, High Authority Backlinks that Will Increase Your Google Rankings in 2020... CLICK HERE ...
    ... Instant backlinks that can get you results within 24-72hrs.
    {{ DiscussionBoard.errors[2201536].message }}
  • Profile picture of the author KirkMcD
    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.
    {{ DiscussionBoard.errors[2202785].message }}

Trending Topics