请高手指教：用OPENROWSET从EXCEL导入到SQL SERVER 2000时，部分数据为空值？

Question

如题
关键代码如下：
INSERT INTO dbo.SupplyList
(I_FAC_CD,I_PO_DETAIL_NO,I_SPLY_TO_CD,I_SPLY_TO_ARG_DESC,I_ITEM_CD,I_SPLY_SCH_QTY,I_SPLY_SCH_DATE,I_SPLY_FRM_ITEM_CD,I_LOT_QTY,I_EXPEND_LOT)
SELECT I_FAC_CD,I_PO_DETAIL_NO,I_SPLY_TO_CD,I_SPLY_TO_ARG_DESC,I_ITEM_CD,I_SPLY_SCH_QTY,I_SPLY_SCH_DATE,I_SPLY_FRM_ITEM_CD,I_LOT_QTY,I_EXPEND_LOT
FROM 
OPENROWSET( 'Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\Supply List.xls',
[SupplyList$])

Answer 1

http://community.csdn.net/Expert/topic/5086/5086676.xml?temp=.6890528