Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Create insert statement using excel Expand / Collapse
Author
Message
Posted Wednesday, August 31, 2011 9:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 1, 2011 12:20 AM
Points: 2, Visits: 7
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
Post #1168466
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse