Excel syntax for SQL string

Question

I need to write an SQL insert statement in cells that reference another cell. What would be the correct syntax to do this? The part that needs to reference another cell is written below as {value of cell} :

INSERT INTO map.UserSurveys (surveyId,userId,activeQuestions) VALUES (50, {value of cell}, 1)

aF. · Accepted Answer · 2012-05-31 12:11:02Z

2

If the value is a number:

="INSERT INTO map.UserSurveys (surveyId,userId,activeQuestions) VALUES (50, " & A1 & ", 1)"

If the value is a string:

="INSERT INTO map.UserSurveys (surveyId,userId,activeQuestions) VALUES (50, '" & A1 & "', 1)"

In both cases replace A1 for the cell that you want and voilá

edited May 31, 2012 at 12:11

answered May 31, 2012 at 12:00

aF.

67k45 gold badges141 silver badges200 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

codingbiz · Accepted Answer · 2012-05-31 12:06:37Z

0

In case you have to put string quote around A1

="INSERT INTO map.UserSurveys (surveyId,userId,activeQuestions) VALUES (50, '" & A1 & "', 1)"

answered May 31, 2012 at 12:06

codingbiz

26.4k9 gold badges62 silver badges99 bronze badges

Collectives™ on Stack Overflow

Excel syntax for SQL string

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related