Help creating insert statement using Excel

• stklingberg

  SSC Journeyman

  Points: 90

  More actions

  August 31, 2011 at 10:49 pm

  #75606

  Hi,

  I'm pretty green at this, any help would be great:

  I'm trying to write an insert statement so that it looks like this:

  insert into stk_location (Item_Code, Whouse_code) Values ('column J', 'VN09')

  I've entered it into Excel like so, but it keeps throwing up errors:

  ="insert into stk_location (Item_Code, Whouse_code) Values ('"&J3&"', 'VN09')

  This is the only part of the statement that needs to look at a field in the same sheet - '"&J3&"' all other items are text only.

  thanks

• Aparna-1

  SSCrazy

  Points: 2339

  More actions

  September 1, 2011 at 12:13 am

  #1375796

  Hi I generally use concatenate function in excel to see how my insert statement builds up.

  Hope this solves your problem.

  =CONCATENATE("INSERT INTO stk_location "," (item_Code, Whouse_Code)"," Values","( '",J$3,"' ,","'","VN09","'"," )")