c# BulkCopy与SQL Server精简版，是可能的

我的目的是复制excel数据到SQL Server精简版。

我从这里读到了SQL Server Compact和SQL Server的区别，但是找不到它。

另外，要知道SqlBulkCopy的构造函数接受SqlConnection参数，而不是sqlcecconnection参数。

下面是我的代码:

public void importDataFromExcel(string excelFilePath)
{
        string sSQLTable = "Inflations";
        string myExcelDataQuery = "Select CUSIP,FM,TNT,CPI_INDEX from [Sheet1$]";
        string sExcelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + excelFilePath + ";Extended Properties=" + "'"Excel 8.0;HDR=YES;'"";
        string sSqlConnectionString = "Data Source=C:''Users''abc''Documents''datafile.sdf;Password=12345;";
        OleDbConnection OleDbConn = new OleDbConnection(sExcelConnectionString);
        OleDbCommand OleDbCmd = new OleDbCommand(myExcelDataQuery, OleDbConn);
        OleDbConn.Open();
        OleDbDataReader dr = OleDbCmd.ExecuteReader();
        SqlBulkCopy bulkCopy = new SqlBulkCopy(sSqlConnectionString);
        bulkCopy.DestinationTableName = sSQLTable;
        while (dr.Read())
       {
            bulkCopy.WriteToServer(dr);
        }
        OleDbConn.Close();
}