Google是你的朋友。经常拜访他。

我发现这个 http://support.microsoft.com/kb/321686& / a> [ ^ ]马上。



如果您想仔细阅读整个搜索结果：如何将Excel数据导入MS SQL [ ^ ]

Google is your friend. Visit him often.
I found this one http://support.microsoft.com/kb/321686[^] right away.

If you wish to peruse the entire search results: how to import the excel data to MS SQL[^]

有很多方法，哪种方法***取决于许多因素，例如：

0）你需要多长时间加载它

1）databa如何你想成为一个不可知论者吗？
2）它应该是一个企业解决方案



我有一个命令行实用工具这样做，我偶尔使用它或者当我得到一个新的数据源时，但是对于每日生产数据，我使用SSIS。

There are many ways and which is best depends on a number of factors, such as:
0) How often you need to do load it
1) How database-agnostic you want to be
2) Should it be an "enterprisey" solution

I have a command-line utility that will do that and I use it for an occasional load or when I get a new data source, but for daily loads of production data I use SSIS.