Databases :: OleDbDataReader Can't Read Excel Cell With Bracket

May 21, 2010

I have an excel header that has the following header title : "REMARKS (i.e. awarded etc.)"

but it seems that it can't read the cell with the brackets or it is there is a certain length of the excel header?

While reader.Read()
Dim DataRow As DataRow = dtDataTable.NewRow()
DataRow("Remarks") = Trim(reader("REMARKS i.e. awarded etc.").ToString)
dtDataTable.Rows.Add(DataRow)
End While

View 3 Replies


Similar Messages:

Databases :: Some Of The Cell Value Can't Read From Excel?

Aug 30, 2010

Im reading some data from the excel file, using below code

objBusy = new BusinessLogic();
string strFileName = FileUpload1.PostedFile.FileName;
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strFileName + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection objConn = new OleDbConnection(connectionString);
objConn.Open();
String strConString = "SELECT * FROM [Product1$]";
//where date = CDate('" + DateTime.Today.ToShortDateString() + "')";
OleDbCommand objCmdSelect = new OleDbCommand(strConString, objConn);
// Create new OleDbDataAdapter that is used to build a DataSet
// based on the preceding SQL SELECT statement.
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
// Pass the Select command to the adapter.
objAdapter1.SelectCommand = objCmdSelect;
// Create new DataSet to hold information from the worksheet.
DataSet objDataset1 = new DataSet();
objAdapter1.Fill(objDataset1, "ExcelData");

after this if i looks on the DataSet i see some of the cell value not read from the Excel file, what was the problem and how to resolve this?

View 5 Replies

Databases :: Importing Excel Sheet Into Sql Server Table Using OleDbDataReader?

Feb 12, 2010

I am trying to Importing Excel sheet into Sql server table using OleDbDataReader

the problem is it is not fetching the cell values with contains "," (comma) ex: cell value ="03280, 03281"

i am using OleDbConnection oconn =

new
OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source="
+ Server.MapPath("Files\LineItems.xlsx") +
";Extended Properties='Excel 12.0 Xml;HDR=YES;IMEX=1';");

View 1 Replies

Databases :: How To Read All Excel Sheets

Feb 19, 2011

I have 1 excel file 2007 that contains 10 sheets

First sheet Name : Remarks that contain only one column for remarks

the other 9 sheets name : Date1 Date2 Date3 Date4 Date5 Date6 Date7 Date8 Date9

each of the 9 sheets has 2 columns: Product Description and Qantity

I am using

[code]....

View 5 Replies

Databases :: How To Read Excel Table

Aug 18, 2010

If I use Microsoft.Jet.OLEDB.4.0 to retreive for example named range or sheet from Excel and use it as data source for some server control on the ASP page, everything works fine. But when I try to get table from Excel like this: "select * from [Table1]", debugger complains that database engine could not find object Table1. So how should I reference Table1 in Excel file so that the database engine could find it?

View 2 Replies

Databases :: Read Data From Excel

Aug 31, 2010

i had 2 columns in the excel file one is SNo and another Description

looks like below
Sno Description
1 1/2 Feet
2 1/5 Feet
3 20
4 30

i read the data from this file using below code

string strFileName = FileUpload1.PostedFile.FileName;
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strFileName + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection objConn = new OleDbConnection(connectionString);
objConn.Open();
String strConString = "SELECT * FROM [Product Classification 5$]";
//where date = CDate('" + DateTime.Today.ToShortDateString() + "')";
OleDbCommand objCmdSelect = new OleDbCommand(strConString, objConn);
// Create new OleDbDataAdapter that is used to build a DataSet
// based on the preceding SQL SELECT statement.
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
// Pass the Select command to the adapter.
objAdapter1.SelectCommand = objCmdSelect;
// Create new DataSet to hold information from the worksheet.
DataSet objDataset1 = new DataSet();
objAdapter1.Fill(objDataset1, "ExcelData");

but in it doesnt read the Description data of 20 & 30 because somebody said if the first cell value is string type then all the column should be string but in mycase its coming as mixed(alpha & numeric), so that it cant read the data, i tried to convert the column as Text then also the same problem continues,

View 3 Replies

Databases :: How To Read Two Sheets From Excel

Aug 5, 2010

i need to edit this code to read two worksheet from excel ?

i have this code to read the first sheet from work sheet

[Code]....

View 1 Replies

Databases :: How To Read Excel Files Using C# .net

Dec 16, 2010

I want to read Excel file . how to do it in simple way.

View 2 Replies

Databases :: How To Read Excel Column Like %%

Mar 12, 2011

I have read the excel in asp.net. I am using OledbDatareader for read the column name.

[Code]....

Now my problem is the "date" field. If Excel sheet having column name "Date" then i got the error. i could not use the Column index because its also not fix. How can i ignore the upper case charactors in column name ?

View 6 Replies

Databases :: Read / Write Excel Page Using Vb

Aug 6, 2010

i have been searching a lot but i didn't find my specefic result, my question is: how can i read excel sheet from asp.net using vb and how can i insert values into a worksheet from my web page

View 4 Replies

Databases :: Read And Write Excel In Website

Oct 13, 2010

i want to ask whether we can read and write excel in website by using asp.net i don't want user to download the excel file and after edit upload again to website. what i want is user can read the excel file in website, after they edit, save the excel

View 4 Replies

Databases :: How To Read Data From Excel Sheet

Jul 7, 2010

I want to create a application which can be able to read data from excel sheet and process and print it.

View 3 Replies

Databases :: Read And Display The Excel Data?

Oct 8, 2010

I have 3 excel files having uniqe column Name JobNo. i want to develop a web page containing serach option based on Jobno.

User just type the jobno and press on search button corresponding record should be display on grid view.record may present any of the excel sheet.how can i acheive this.

View 3 Replies

Databases :: Read Picture From Excel File

Nov 11, 2010

i can't read picture from file excel in code asp.net

View 2 Replies

Databases :: How To Read Excel File From Web Application (C#)

Aug 21, 2010

I have a web app where user uploads a file.ile is saved in server locally and I want to read some data from it.Currently my development server has office 2003.So do I need office 2007 in order to be able to read an excel from office 2007 ?

Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook wrkBook; // = new Microsoft.Office.Interop.Excel.Workbook();

View 3 Replies

Databases :: Read Excel Files Using Oledbreader Row By Row?

Aug 5, 2010

i'm trying to read an excel file and get data on a row by row basis. Since after converting the pdf file into an excel file, the formatting went a bit haywire but if read row by row, i'm still able to retrieve the original data.

As I am unable to generate the excel file using a single worksheet, i have multiple sheets in the excel file. I also need help on reading multiple sheets.

Currently i am onli able to get data via columns but due to the formatting going haywire, i gave up on it.

View 1 Replies

Databases :: How To Read Excel Using C# And Store In Oracle Database

Jun 9, 2010

How do I read excel(with many worksheets) using asp.net c# and load the data into oracle database?

View 2 Replies

Databases :: How To Read Excel Sheet From 3rd Row Using Oledb Provider

Oct 26, 2010

I have a excel sheet and I want to make the 2nd row my header column and read the data from the 3rd row, considering 2nd row is the Column name.

View 1 Replies

Databases :: Unable To Read Image From Excel File

Nov 18, 2010

Iām trying to read images from an excel file using OleDbDataReader. My excel file has 6 columns of data, the first 5 are all text but the last is image. While Iām reading the record, It's doing fine on the first 5 columns but return me with a for the sixth column.

Here is my demonistration code:

[code]....

View 4 Replies

Databases :: Read Excel Header Name And Put Into SELECT Statement?

Sep 7, 2010

I'm trying to read Excel file header column name. Then I can query data from excel using SELECT statement. For instance. column name is name,

department and email. Then I want this three header name being detected using code and put in select statement. User no need to care about the

header name and we can use code to read the header name instead of hardcode header name inside SELECT statement.

View 1 Replies

Databases :: Read Excel Data From Stream Or Byte Array?

Jan 10, 2011

My web page contains a file upload control that is used to select excel file. What my code does; is to read the content of that file and store its content to DB. Right now, I save this file to server and read its content using OLEDB.I want to know is there any way i can read the content without saving it on the server?

View 2 Replies

Databases :: Upload An Excel File And Read In Memory Without Saving?

Mar 15, 2011

I need to upload an excel file using a web application. Then I need t oread it in memory without saving it on the server.

Does the file need to have headers? Also the data is such that it may have or may not have values for some columns.

View 1 Replies

Databases :: Read An Excel File And Show Data From 2 Columns?

Sep 11, 2010

I have an Excel file called Products.xls .I have Columns A and B, with the titles NAME and QUANTITY.The name of the sheet is SHEET1.The file has about 40 lines.How do i show these data on a Gridview or Listview ?

View 4 Replies

Databases :: Read Excel File From 5th Row Onwards - Store All Records Into Database

Mar 18, 2010

I am facing problem..how to read Excel file from the 5th row onwards and how to store the all records into Database Note: More over i do want store few coloumns records(3 out 8) only in my database. consider this point.

View 4 Replies

Databases :: Read Write Excel File In Application Without Installing The Office On Server

Jan 8, 2010

I want to read write excel file in my application without installing the office on my server. Means my server don't have any excel (MS office) installation. Is it necessory to install the office on server to excute the program of read or write the excel file.

View 5 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved