当然! 用ADOCONNECTION连上你的ACCESS数据库 用ADOQUERY查询就可以了 WITH ADOQUERY DO BEGIN CLOSE SQL。CLEAR; SQL。TEXT=‘SELECT * FROM TABLE’; OPEN;END;
用ADOCONNECTITON与ACCESS相连ADOQUERY可以使用SQL语句 with adoquery1 do begin Close; sql.clear; sql.add('select * from table') Open; end;
首先,你得设置ADOQuery1.ConnectionString:="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=bugs.mdb;Persist Security Info=False" with adoquery1 do begin Close; sql.clear; sql.add('select * from table') Open; end;
先要配置ADOCONNECT的 CONNECT STRING;
然后,
begin
close;
sql.clear;
sql.add();
end
http://www.delphibox.com/downloads.asp?subcatalogid=101
用ADOCONNECTION连上你的ACCESS数据库
用ADOQUERY查询就可以了
WITH ADOQUERY DO
BEGIN
CLOSE
SQL。CLEAR;
SQL。TEXT=‘SELECT * FROM TABLE’;
OPEN;END;
with adoquery1 do
begin
Close;
sql.clear;
sql.add('select * from table')
Open;
end;
with adoquery1 do
begin
Close;
sql.clear;
sql.add('select * from table')
Open;
end;