Excel cell format

Hi Expert,
I have problem to read one column whose format is text. On the spreadsheet I see
all values, but when I read it by using oledb some line of the same column returned
null. Then I check its format. it is text and possibly has 'apostrophy' infront. Then I add
" ' " in front of the cell, then I can read it.
How can I use excel macro to check if the cells in this column named has " ' " if not ,
my macro will add " '". I am new to macro excel.
Could you please help me out?
Thx,'
JT

OleDbCommand cmd3 = new OleDbCommand("select * from [" + txtSheetName.Text + "$]", con);
            using (rd = cmd3.ExecuteReader())
            {
                int index = 0;
 
                while (rd.Read())
                {
                    index++;
 
                    if (index < DataRowIndex - 1)
                    {
                        continue;
                    }
                    else if (index == int.Parse(txtEndedData.Text.ToString()) - 1)
                    {
                        goto closing;
 
                    }
 
                    string countryId = null;
                    if (countryName != null)
                    {
                        countryId = valid(rd, CountryNameIndex);
                        //countryId = rd[CountryNameIndex].ToString();
                    }
                    string Destination = null;
                    Destination = valid(rd, DestIndex);
                    if (Destination.Equals("")) continue;
                    string countryCode = null;
                    if (DNCountry != null)
                        countryCode = valid(rd, DNCountryIndex);
                    //countryCode = rd[DNCountryIndex].ToString();
                    string cityCode = null;
                    cityCode = valid(rd, DNAreaIndex);
                    string Rate = null;

Select allOpen in new window

sheetname-err.xls