[经验]导入Excel数据到Sql Server
摘要：
如果excel中有一列为数字列，比如1,999.05，那么导入的过程中会提示转换字符串到数字出错这是因为程序不会自动将逗号去除，所以在导入的时候需要先将逗号REPLACE处理掉； 阅读全文
posted @ 2011-01-20 11:11 jes 阅读(160) 评论(0) 推荐(0)
奋斗中...
曾经的程序员。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号