Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel into DataTable using OleDbDataAdapter
Query fails to fetch Excel data formatted as currency. How can I get
currency data from Excel into a .NET DataSet. This query works fine for all other Excel Data fields! Thank you for your help. //=========================== string xlsFile = fullFilePathStr; DataSet importDS = new DataSet(); OleDbConnection objConn = null; System.Data.DataTable dt = null; string connString; connString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + xlsFile + ";" + "Extended Properties=Excel 8.0;"; objConn = new OleDbConnection(connString); // Open connection with the database. objConn.Open(); // Get the data table containg the schema guid. dt = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables , null); try { OleDbDataAdapter myCommand = new OleDbDataAdapter( " SELECT * FROM [" +worksheetNameStr+ "$] ", objConn); myCommand.AcceptChangesDuringFill=true; importDS.EnforceConstraints=false; myCommand.Fill(importDS); } catch(Exception ex) { string exStr = ex.ToString(); } finally { if(objConn != null) { objConn.Close(); objConn.Dispose(); } if(dt != null) { dt.Dispose(); } } |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel into DataTable using OleDbDataAdapter
Matthew_H wrote:
Query fails to fetch Excel data formatted as currency. How can I get currency data from Excel First, ensure your data actually is of type Currency. Formatting is a factor but no guarantee e.g. Text in a column with a currency format is still Text. Ensure you do not have a mixed types situation - see: http://www.dicks-blog.com/archives/2...ed-data-types/ Jamie. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart's DataTable | Charts and Charting in Excel | |||
Needing to re-order a datatable display on an Excel chart | Charts and Charting in Excel | |||
Can anyone align the numbers within the datatable of a chart? | Charts and Charting in Excel | |||
DataTable number format | Excel Programming | |||
Problems using VB.Net OleDbDataAdapter and Excel | Excel Programming |