我用adoconnection1连接excel的连接字符串,但是如果设置将Excel加密码保护,就老是连接不成功,请问,我该怎么改变下面的连接字符串呢,才能进行正确连接呢?
adoconnection1.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+ edit1.Text +';Database Password=123456;Extended Properties=excel 8.0;Persist Security Info=false';
adoconnection1.connected=true;
adoconnection1.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+ edit1.Text +';Database Password=123456;Extended Properties=excel 8.0;Persist Security Info=false';
adoconnection1.connected=true;
+ExtractFilePath(application.ExeName)//ParamStr(0))
+'1.xls;Persist Security Info=False;Extended Properties=Excel 8.0;Jet OLEDB:DataBase PassWord=123';
ADOConnection1.Connected:=True ;