急问:Excel的数据导入???

Question

  
SELECT *   
--into a2  
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',   
                'Excel 8.0;IMEX=1;HDR=YES;Database=E:\tsb.xls', [sheet1$])  
---------------------------------------------test------
a/b                                                                                                                                                                                                                                                             ab                                                    Total                                                 
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------- ----------------------------------------------------- 
8.00                                                                                                                                                                                                                                                            100.0                                                 800.0
8.00                                                                                                                                                                                                                                                            100.0                                                 800.0
21.32                                                                                                                                                                                                                                                           700.0                                                 14924.0
21.32                                                                                                                                                                                                                                                           100.0                                                 2132.0
21.87                                                                                                                                                                                                                                                           125.0                                                 2733.75
21.87                                                                                                                                                                                                                                                           675.0                                                 14762.25(影響 6 個資料列)

Answer 1

或者用楼上的方法,注意参数中的:;IMEX=1 不能少

Answer 2

怎么我的出现这样的错误：服务器: 消息 7399，级别 16，状态 1，行 1
OLE DB 提供程序 'Microsoft.Jet.OLEDB.4.0' 报错。提供程序未给出有关错误的任何信息。 

Answer 3

这种问题最好是先把Execl的单元格类型做好规定，先在Excel中用宏做好格式，就没那么多麻烦了。如果已经做好就，在先做张空的Excel格式表，然后把Excel中的数据复制到一个文本文件，再把文本文件中的数据复制到格式表中，或者干脆就用文本文件。