for (int i = 0; i < cols; i++)
{
if (i < cols - 1)
sb.Append(string.Format("{0} varchar,", dt.Columns[i].ColumnName));
else
sb.Append(string.Format("{0} varchar)", dt.Columns[i].ColumnName));
}
connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" + excelPath + ";Extended Properties=Excel 8.0";
using (OleDbConnection objConn = new OleDbConnection(connString))
{
OleDbCommand objCmd = new OleDbCommand();
objCmd.Connection = objConn;
objCmd.CommandText = sb.ToString();
for (int i = 0; i < cols; i++)
{
if (i < cols - 1)
sb.Append(string.Format("{0} text,", dt.Columns[i].ColumnName));
else
sb.Append(string.Format("{0} text)", dt.Columns[i].ColumnName));
}