1

I want to import the data from xls to my MYSQL database,but problem is that the data/columns present in xls file is from different number of tables. Suppose we have column col1,col2,col3,col4,col5,col6 from xls. col1,col3 from table1 and col2,col4 from table2 and col5,col6 from table3

How can i import these all columns field data to those corresponding tables through c# code?

Improve this question
3
  • it is called mapping. Commented Dec 20, 2013 at 9:23
  • Maybe you can refer to this topic Commented Dec 20, 2013 at 9:31
  • We can say it is mapping,but i want to insert those cols to proper table to which it belongs. and also the cols there in xls are having alias for some col lets suppose for col1 will be displayed in xls as column1 it should go to table1 as col1. thanx Commented Dec 20, 2013 at 9:39
Related questions
1
How to update MYSQL Database with data from Excel using ASP.NET?
13
Uploading an Excel sheet and importing the data into SQL Server database
0
How to upload table data from Excel to SQL Server 2008 in C# ASP.Net
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.