Last post Feb 12, 2015 02:41 AM by Zhi Lv - MSFT
Dec 26, 2014 12:35 AM|Krissh Parthi|LINK
When I’m going to uploading Microsoft excel 2010(.xlsx) file the sheet values are given wrong values. becoz i converted the entire sheet values are accounting format and when I’m going to read excel sheet through Microsoft.ACE.OLEDB.12.0
provider the 0 values are returns -(hyphen) values actually it's possible to Excel 2007(.xls) but here I used Microsoft.Jet.OLEDB.4.0 provider. Anybody had known this problem kindly support with me.
Thanks & Regards,
Dec 26, 2014 10:39 AM|Lannie|LINK
Try IMEX setting in connection string IMEX = 1
Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1";
Dec 28, 2014 11:07 PM|Krissh Parthi|LINK
I aslo used this OleDbConnection provider.
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Karthick\Test Application\Remarks_Price.xlsx; Extended Properties='Excel 12.0 xml;HDR=Yes;IMEX=1'
But That is also not working properly. kindly give me any another ideas.
Tanks and Regards,
Dec 29, 2014 10:49 PM|Lannie|LINK
Dec 29, 2014 11:01 PM|Krissh Parthi|LINK
That is also not suitable to my problem...!
Jan 01, 2015 05:34 PM|Lannie|LINK
Show your .NET code used to load the EXCEL spreadsheet into your target.
Perhaps we can help you modify formatting of values after they are extracted from Excel.
Feb 12, 2015 02:41 AM|Zhi Lv - MSFT|LINK
Hi Parthiban K,
As for this issue, I suggest you could refer to the following articles about
import data from Excel into a DataSet or database.
Upload Excel Spreadsheet File to Server, then Display Record(s) in Gridview
Import Excel File to DataSet
Read and Import Excel Sheet into SQL Server Database in ASP.Net