con1: TFDConnection; fdqry1: TFDQuery; fdgxwtcrsr1: TFDGUIxWaitCursor; fdphysdbcdrvrlnk1: TFDPhysODBCDriverLink; btn1: TButton; //链接按钮 btn2: TButton; //查询按钮 ds1: TDataSource; dbgrd1: TDBGrid;
2，fdqry1.connection属性为con1,ds1.dataset属性为fdqry1,dbgrd1.datasource属性为ds1,其中con1的属性如下：注意，设计时请将con1.connected属性值设为fasle，否则编译时会报错。procedure TForm1.btn1Click(Sender: TObject);begincon1.Connected:=True;end;procedure TForm1.btn2Click(Sender: TObject);beginfdqry1.Close;fdqry1.sql.Text:='select * from [yh$]' ;fdqry1.open;end;
4，表名为yh，但是因为是excel所以必须加上$和[]，所以在sql语句中为[yh$]
