[经验]导入Excel数据到Sql Server
如果excel中有一列为数字列，比如1,999.05，那么导入的过程中会提示转换字符串到数字出错
这是因为程序不会自动将逗号去除，所以在导入的时候需要先将逗号REPLACE处理掉；
奋斗中...
曾经的程序员。ASP.NET/C#, JavaScript, PL/SQL, T-SQL; 工具: VS2003/2005, Oracle, SQLServer; 偶尔写点CSS, 批处理.
头脑中经常有新想法, 可惜没有去实现.
Never give up.
Never get into a fight with a pig. Both of you will get dirty. But the pig actually enjoys it.
头脑中经常有新想法, 可惜没有去实现.
Never give up.
Never get into a fight with a pig. Both of you will get dirty. But the pig actually enjoys it.
浙公网安备 33010602011771号