在access里面查询链接有密码的excel表

SELECT *
from [excel 8.0;User ID=Admin;Database=F:\system\desktop\数据.xls].数据


怎样才能查询加密了的excel文件呢~~

---

不能，只能用OLE方式打开加密了的excel文件

---

SELECT *
from [excel 8.0;User ID=Admin;Database=F:\system\desktop\数据.xls;Mode=Read;Extended Properties="HDR=YES;";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Engine Type=35;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False].数据;

这个也不行哈~~~~~~

{{