This should be the correct syntex, replace your line with below:

var sqldata = sqlInsertBase+"("+data[i][0]+",'"+data[i][1]+"','"+data[i][2]+"');";

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

Developers Group
Developers Group

Written by Developers Group

A Developer is responsible for coding, designing, deploying, and debugging development projects, typically on the server-side (or back-end).

Responses (1)

Write a response

Thank you! Fixed my issue. I was also wondering is it possible for the data to be updated and not duplicate itself? When I want to update the sheets into the database it duplicates the data into the table instead of only adding the new data into the database.