在delphi中如果实现把ACCESS数据表转化为EXCEL表格形式? 在delphi中如果实现把ACCESS数据表转化为EXCEL表格形式?哪个组件有此功能,(TbatchMove组件行吗?) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 导入与导出,你试一下;acStore: TADOConnection;...procedure TfrmEhlib.btnToExcelClick(Sender: TObject);var fName: string;begin fName := ExtractFilePath(Application.ExeName) + 'store.xls'; if FileExists(fName) then DeleteFile(fName); try acStore.Execute('select * into [Excel 8.0; Database=' + fName + '].[sheet1] from stable'); MessageBox(self.Handle, '数据已成功导出为store.xls', '提示', mb_IconInformation + mb_Ok); except MessageBox(self.Handle, '数据导出失败!', '提示', mb_IconInformation + mb_Ok); end;end;procedure TfrmEhlib.btnFromExcelClick(Sender: TObject);var tName: TStrings;begin if not FileExists(ExtractFilePath(Application.ExeName) + 'store.xls') then Exit; tName := TStringList.Create; acStore.GetTableNames(tName, false); if tName.IndexOf('sExcel') >= 0 then acStore.Execute('drop table sExcel'); acStore.Execute('select * into sExcel from [Excel 8.0; Database=' + ExtractFilePath(Application.ExeName)+ 'store.xls' + '].[sheet1$]'); MessageBox(self.Handle, 'Excel已成功导入表sExcel', '提示', mb_IconInformation + mb_Ok); tName.Free;end; ADO指向EXCEL:ADOQUERY:select * into XLSFILE from TABLENAME in "d:\TEMP\123.mdb" "jet 3.x;" 用ado分别连接access和excel,然后想怎么办就随便了,其连接字符串如下:access:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;excel:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1" 向(kye_jufei)提問:Delphi如何根據cxgrid單元格中的數據動態自繪顔色??? delphi中怎样获取当前记录,并更新当前记录后的所有记录 请教多线程连接数据库问题 TNMStrm 这个控件哪里有下啊? 请求dxDBGrid的问题,急 送出最后19分:老天爷呀!!安装连接数据库问题!是不是出妖怪了!! 菜单背景颜色的设置 含有(group by)的Sql语句dbgrid不显示分组字段吗? delphi和vb比较 如何把delphi3或4的組件(有原碼)改成D5的组件? 如何用DELPHI编写QQ在线查看器. 有谁知道在武汉做DELPHI开发多少钱啊???
...
procedure TfrmEhlib.btnToExcelClick(Sender: TObject);
var
fName: string;
begin
fName := ExtractFilePath(Application.ExeName) + 'store.xls';
if FileExists(fName) then DeleteFile(fName);
try
acStore.Execute('select * into [Excel 8.0; Database=' + fName + '].[sheet1] from stable');
MessageBox(self.Handle, '数据已成功导出为store.xls', '提示', mb_IconInformation + mb_Ok);
except
MessageBox(self.Handle, '数据导出失败!', '提示', mb_IconInformation + mb_Ok);
end;
end;procedure TfrmEhlib.btnFromExcelClick(Sender: TObject);
var
tName: TStrings;
begin
if not FileExists(ExtractFilePath(Application.ExeName) + 'store.xls') then Exit;
tName := TStringList.Create;
acStore.GetTableNames(tName, false);
if tName.IndexOf('sExcel') >= 0 then
acStore.Execute('drop table sExcel');
acStore.Execute('select * into sExcel from [Excel 8.0; Database=' + ExtractFilePath(Application.ExeName)+ 'store.xls' + '].[sheet1$]');
MessageBox(self.Handle, 'Excel已成功导入表sExcel', '提示', mb_IconInformation + mb_Ok);
tName.Free;
end;
ADOQUERY:
select * into XLSFILE from TABLENAME in "d:\TEMP\123.mdb" "jet 3.x;"
access:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;
excel:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"