var cat:olevariant; s:string; begin s:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+dbname; if password<>'' then s:=s+';Jet OLEDB:Database Password='+password; cat:=createoleobject('adox.catalog'); try cat.create(s); result:=true; except result:=false; end;
是JRO
用法和DAO一样的
用ADOX
压缩才是用JRO
s:string;
begin
s:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+dbname;
if password<>'' then
s:=s+';Jet OLEDB:Database Password='+password;
cat:=createoleobject('adox.catalog');
try
cat.create(s);
result:=true;
except
result:=false;
end;
当我建立了mdb数据库和其中数据表,怎样将SQL Server的数据表记录导入,用TSQL行不行,用ADOX的方法呢?