27,580
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="C:\Documents and Settings\Administrator.QCKJ-DAO2CB2E5U\桌面\Book1.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[sheet1$]
EXEC sp_configure 'show advanced options', 1
RECONFIGURE
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
RECONFIGURE
GO
SELECT * INTO excel_import
FROM OPENROWSET(
'Microsoft.Jet.OLEDB.4.0',
'Excel 5.0;Database="C:\Documents and Settings\Administrator.QCKJ-DAO2CB2E5U\桌面\Book1.xls"',
'SELECT * FROM [sheet1$]'
)
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 0
RECONFIGURE
GO
EXEC sp_configure 'show advanced options', 0
RECONFIGURE
GO
这样再试试,不行可能需要重装OFFICE了。