ADO打開操作Excel
Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=E:\My Documents\資金流水帳.xls;Extended Properties=Excel 5.0;Persist Security Info=False
查詢分析器裡面Open Excel資料
SELECT *
FROM OpenDataSource
('Microsoft.Jet.OLEDB.4.0',
'Data Source="E:\mfProgram\sferpProject\Release\Server\期初導入.xls";User ID=Admin;Password=;Extended properties=Excel 5.0'
)...[Sheet1$]
![“雲管邊端”協同的邊緣計算安全防護解決方案0 引 言1 5G 及邊緣計算2 邊緣計算面臨的風險3 “雲管邊端”安全防護技術4 “雲管邊端”安全防護實踐5 結 語[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)