Csv批量导入Access代码,Asp.Net代码库,德仔网

代码语言

代码分类

【Asp.Net】 Csv批量导入Access

作者:Sarah / 发布于2015/3/24/ 1023


	/// <summary>
	 /// 向Access插入数据
	 /// </summary>
	 /// <param name="AccessPath"></param>
	 /// <param name="AccessName"></param>
	 /// <param name="CsvName"></param>
	 /// <param name="CsvPath"></param>
	 public static bool InsertAccess(string AccessPath, string AccessName, string CsvName, string CsvPath, out string vErr)
	 {
	 bool bRet = false;
	 vErr = string.Empty;
	 try
	 {
	 vErr = string.Empty;
	 string ConnnectionString = string.Format(@"Provider='Microsoft.Ace.OLEDB.12.0';Data Source={0}\\{1}.accdb", AccessPath, AccessName);
	 OleDbConnection Accessconn = new OleDbConnection(ConnnectionString);
	 try
	 {
	 OleDbCommand Accesscomm = new OleDbCommand();
	 string AccessCommText = string.Format(" select * into [{0}] from [Text;HDR=NO;IMEX=1;FMT=Delimited;ImportMixedTypes=Text;DATABASE={1}].[{2}] ", AccessName, CsvPath, CsvName);
	 Accessconn.Open();
	 Accesscomm.CommandText = AccessCommText;
	 Accesscomm.Connection = Accessconn;
	 Accesscomm.ExecuteNonQuery();
	 bRet = true;
	 }
	 catch (Exception vTemp)
	 {
	 vErr += vTemp.Message + "\r\n";
	 MessageBox.Show(vTemp.Message);
	 }
	 finally
	 {
	 Accessconn.Close();
	 Accessconn.Dispose();
	 }
	 }
	 catch (Exception ex)
	 {
	 vErr += ex.Message + "\r\n";
	 }
	 return bRet;
	 }

	

	提示：有个缺点，IMEX=1 的设置不管用，格式不转变。

试试其它关键字

　导入Access　

同语言下

可能有用的

Sarah贡献的其它代码(10)