Excel導入Sql Server數字導入問題解決
1.将單元格格式設定為 正常
2.導入的sql語句
use test
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
go
SELECT * INTO spacefield
FROM OpenDataSource
('Microsoft.Jet.OLEDB.4.0','Data Source="D:\導入\spacefield.xls";Extended properties="Excel 5.0;HDR=Yes;IMEX=1;"')...['spacefield$']
3.通過實驗,數值,文本導入之後都沒問題了。
轉載于:https://www.cnblogs.com/stublue/archive/2010/11/15/1877634.html