Create insert statement using excel

• stklingberg

  SSC Journeyman

  Points: 80

  More actions

  August 31, 2011 at 9:30 pm

  #247223

  Hi all,

  I'm pretty green at this and have never done this unsupervised, would appreciate any assistance.

  I'm trying to make the insert statement look like this:

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

  I'm entering it like so but Excel throws up an error:

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

  '"&J3&"' is from within the same sheet, but all other items are text.

  thanks