how to extracting data from Excel to Access in c#

ber88 · #1 (**permalink**) 11-19-07, 12:44 PM

Quote:

Originally Posted by cancer10

Hello All,

Can someone help me with this problem?

I have 3 colums in an excel sheet (Serial No, Name, Mobile no), I want to put all the data in the excel sheet into the database which also has 3 colums (Serial No, Name, Mobile no) with a single click of a button using ASP.

hi,
my problem is kinda similar, just that, i'm using c# for my language and working on visual studio2005.
i would need to extract 1 column, for example, 'Code' from the ms excel file,

In ms excel...

Name | Number | School
----------------------------------
Terry | 1234J | ASchool
Tom | 7654P| CSchool

then insert the column of data into the existing ms access file below.

In ms access...

Code | num | Role
----------------------------------------------
10A | 5678Y | Player
10B | 8765R | Player
10C | 1234J | Player //number inserted into column
10D | 7654P | Player //number inserted into column

i would kindly appreciate if anyone would code me this

thanks

#2 (**permalink**) 11-21-07, 06:39 PM

you cannot do this in pure asp or asp.net without a thirdparty component to ready .xls files. if you convert them to csv then you can do it rather easily