procedure TForm1.dxBarSubItem2Click(Sender: TObject); var str:string; begin if opendialog1.Execute then begin Str := OpenDialog1.FileName; AdoConnection1.LoginPrompt:=false; ADOConnection1.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;'+'Data Source='+str+';Mode=Read;Extended Properties=Excel 8.0;Persist Security Info=False'; end; end;
procedure TForm1.dxBarSubItem2Click(Sender: TObject); var str:string; begin if opendialog1.Execute then begin Str := OpenDialog1.FileName; AdoConnection1.Close;//应该先关闭AdoConnection1,是不是之前AdoConnection1已经打开了 AdoConnection1.LoginPrompt:=false; ADOConnection1.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;'+'Data Source='+str+';Mode=Read;Extended Properties=Excel 8.0;Persist Security Info=False'; end; end;
adoConnection1.Close;这一句报错,Access violation at address 00000000
1.数据集连接excel,这个ado可以操作
2.数据集连接Grid的数据集
3.exce数据想grid数据集中添加excel中的数据
4.grid数据集Open,把数据显示在grid中
先是用ADOCONNECTION连接了EXCEL,ADOTABEL连接了ADOCONNECTION,然后用DBGRID连接了ADOCONNECT和ADOTABLE,这个是成功的。
然后我就试着用CXGRID连接,可是我第一次用CXGRID,对这个控件不熟悉,连接过程中一直报错,说是对象打开时不允许操作。
var
str:string;
begin
if opendialog1.Execute then
begin
Str := OpenDialog1.FileName;
AdoConnection1.LoginPrompt:=false;
ADOConnection1.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;'+'Data Source='+str+';Mode=Read;Extended Properties=Excel 8.0;Persist Security Info=False';
end;
end;
procedure TForm1.dxBarSubItem2Click(Sender: TObject);
var
str:string;
begin
if opendialog1.Execute then
begin
Str := OpenDialog1.FileName;
AdoConnection1.Close;//应该先关闭AdoConnection1,是不是之前AdoConnection1已经打开了
AdoConnection1.LoginPrompt:=false;
ADOConnection1.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;'+'Data Source='+str+';Mode=Read;Extended Properties=Excel 8.0;Persist Security Info=False';
end;
end;