/// <summary>
/// 将文本文件直接导入数据库
/// </summary>
/// <param name="TableName">导入数据需要的表</param>
/// <param name="FilePath">数据所在文件完整路径</param>
/// <param name="Firstrow">从文件的第几行开始导入数据</param>
/// <param name="fieldterminator">FIELDTERMINATOR 列的分隔符</param>
/// <param name="rowterminator">ROWTERMINATOR 一行的终止符</param>
/// Return:// 成功返回S_OK, 否则返回S_FALSE.
/// Others:// 针对文本类型的数据,关键函数bulk insert
public bool DataDirectIntoSQL(string TableName
, string FilePath
, int Firstrow
, string fieldterminator
, string rowterminator)
{
//自适应此三种字段分隔符的导入 即逗号 分号 Tab
string csSQL = string.Format( "bulk insert {0} from '{1}' WITH ( FIRSTROW = {2},FIELDTERMINATOR = '{3}',ROWTERMINATOR = '{4}' )"
,TableName,FilePath,Firstrow.ToString(),fieldterminator,rowterminator);
return m_dhHelper.ExeQuery(csSQL);
}
Windows 7专业版Service Pack 1
Inter® Core™i5-2400 CPU @3.10GHz 4GB内存
SQL2005
8g数据大约需要30分钟