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
JAYRAM
NA
272
213.9k
inset excel field values in sql table
Jan 4 2015 10:16 PM
I HAVE EXCEL FILE LIKE BELOW .....
Jan'13
Feb'13
Mar'13
Apr'13
TOTAL 2013
Branch Name
code
Sales Qty.
Sales Value
Sales Qty.
Sales Value
Sales Qty.
Sales Value
Sales Qty.
Sales Value
Sales Qty.
Sales Value
s.v.cs branh
AED
12
1,000
10
2,000
40
3,000
40
500
102
6,500
yuot brach
AED3
0
0
0
0
0
0
0
0
0
0
xxx
xxxyyy
i want to insert above values in sql using asp.net
i have sql table like below
Branch Name
code
date
SalesQty
SalesValues
s.v.cs branh
AED
jan'13
12
1000
Feb'13
10
2000
plz write charp code ..........
using dataset ..
iam using below query to insert but iam unable to select date,salesqty,salesvalues in excel sheet
string sql = "INSERT INTO branch (BranchName,code,...................................................)";
sql += "VALUES('" + columns[0] + "','" + columns[1] + "','" + columns[2] + "')";
plz help me???
Reply
Answers (
2
)
IRC client not receiving ident request
below code is not executing please help