TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
viktors
NA
54
0
update a column in a table
Jul 23 2004 12:35 PM
hi i have a situation where-in i want to update a column in the database with one of the fields from the excel sheet. My excel sheet looks something like this : Excel file : ID Name Desc Colourful-Books 1 red hot 2 blue cool 3 black Dark Non-Colourful 1 white pale 2 white1 serene 3 white2 calm after importing the excel file the sql table Book looks like this: ID BOOKNAME DESCRIPTION TYPE 1 Colourful-Books NULL 2 red hot 3 blue cool 4 black dark 5 NULL NULL 6 Non-Colourful NULL 7 white pale 8 white1 serene 9 white2 calm what i want to do is update the type column of the table Book: ID BOOKNAME DESCRIPTION TYPE 1 Colourful-Books NULL NULL 2 red hot Colourful-Books 3 blue cool Colourful-Books 4 black dark Colourful-Books 5 NULL NULL NULL 6 Non-Colourful NULL NULL 7 white pale Non-Colourful 8 white1 serene Non-Colourful 9 white2 calm Non-Colourful can someone please give me some suggestions. thanks.. (sorry tried formatting the data in a table format..wasnt successful....)
Reply
Answers (
1
)
Double click on DataGrid
Numeric value