Export excel to database through c#

Question

0.00/5 (No votes)

See more:

Hi guys,

im trying to import excel into database(SQL server 2008) as it is i.e. with data and columns and not in terms of bytes.... using visual studio 2008 ,asp.net 3.5...
I have approached it in 2 ways;

1)I have used exceldatareader of codeplex http://exceldatareader.codeplex.com/
But this is the dll with lot of bugs eg:date column getting converted to integer,some values are not read... this is really very bad and it has taken a lot of time.

2) I tried using sqlbulkcopy but that also gives an error here:

string xConnStr123 = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + "C:\\movies\\Test.xlsx" + ";" + "Extended Properties=Excel 9.0;HDR=Yes;";

Could not find installable ISAM.

please share the code for importing columns and data into database from excel......
I need it badly....

Posted 4-Jun-12 6:31am

akshay k 2

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2012-06-04T06:53:00

please share the code for importing columns and data into database from excel.
It does not work like this here.

Here is what is expected of enquirers:
1. TRY first what you want to do! You may find that it's not that hard.
2. Formulate what was done by you that looks like an issue/not working.

Try them and tell if you face issues.
Members will be more than happy to help like this.

For now, look here:
how to Import data from EXCEL to SQL Database in ASP.NET[^]
Importing Excel into SQL using ASP.NET 2.0 and SqlBulkCopy[^]

Patrice T · Answer 2 · 2015-10-02T12:22:00

Quote:
1)I have used exceldatareader of codeplex http://exceldatareader.codeplex.com/
But this is the dll with lot of bugs eg:date column getting converted to integer,some values are not read... this is really very bad and it has taken a lot of time.

This is not an error !
In Excel, Date/Time values are stored as a floating point number.
The date is coded as the number of days since a reference date.
The time in day is coded in the fractional part of the value.

the date is simply a display formatting.

date only values look like integers.

I guess you need to use a conversion function to get a date.

Export excel to database through c#

2 solutions

Solution 1

Solution 3

Add your solution here

Preview 0

Export excel to database through c#

2 solutions

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us