Using OleDBDataReader to read Excel not retrieving all of a header column cells content

Question

I have an Excel sheet that I am using to populate data in a Database. It seems as though there is only a certain number of characters that the OleDBDataReader actually reads in from a column heading before truncating the rest.

Is there a way around this?

How I am retrieving the column headings:

OleDbCommand oleDbCommand = new OleDbCommand("select * from [sheet1$]",
OleDbConnection);
OleDbDataReader reader = oleDbCommand.ExecuteReader();
DataTable dataTable = new DataTable();
dataTable.Load(reader);

foreach (DataColumn column in dataTable.Columns)
{
string columnName = column.ColumnName;
}

Expected result: Targeted programs to address the welfare needs of students. E.g breakfast clubs

Actual Result: Targeted programs to address the welfare needs of students. E.g br

I have also tried using the reader.GetName(i) method to retrieve the information with the same result.

dbugger · Accepted Answer · 2011-07-27 02:05:08Z

1

64 characters is the column header limit of the Jet Engine reader.

http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/2fb51d81-3d64-445f-806a-519861b561ba/

Sorry I cannot find a better reference.

answered Jul 27, 2011 at 2:05

dbugger

16.6k10 gold badges34 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rollcredit Over a year ago

Thanks for that. I had a feeling it was something like that.

Collectives™ on Stack Overflow

Using OleDBDataReader to read Excel not retrieving all of a header column cells content

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related