SqlServer文本导入数据
1.SSMS数据导入导出工具
2.Bulk Insert 参考:Bulk Insert命令详细
3.BCP sqlserver2008不支持UTF8格式导入文件(比较坑)。
去空行工具:
1 static void Main(string[] args) 2 { 3 string root = Environment.CurrentDirectory; 4 5 var files = Directory.GetFiles(root, "*.txt"); 6 var encoding = new UTF8Encoding(false); 7 8 foreach (var item in files) 9 { 10 FileStream fsRead = new FileStream(item, FileMode.Open); 11 //fsRead.Seek(3, SeekOrigin.Begin); 12 var fsLen = fsRead.Length; 13 byte[] heByte = new byte[fsLen]; 14 int r = fsRead.Read(heByte, 0, heByte.Length); 15 string myStr = encoding.GetString(heByte); 16 //string myStr = System.Text.Encoding.UTF8.GetString(heByte); 17 myStr = myStr.Replace("\r\n", "\n").Replace("\r","").Replace("\n","\r\n"); 18 19 FileInfo fi = new FileInfo(item); 20 var newFile = fi.Name.Replace(".txt", ".tsv"); 21 22 File.WriteAllText(newFile, myStr, encoding); 23 fsRead.Flush(); 24 fsRead.Close(); 25 26 } 27 28 Console.ReadLine(); 29 }