Create insert statement using excel

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Arun Mallick » Create insert statement using excel

Create insert statement using excel

Rate Topic

Display Mode

Topic Options

Author

Message

stklingberg

Posted Wednesday, August 31, 2011 9:30 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 01, 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 »

Permissions