如何将数据库中的数据导入到Excel中? 将数据库中的数据导入到Excel,要添加什么控件吗?代码怎么编写呢? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 //给个简单例子:unit Stat;interfaceuses OleServer, ExcelXP, Variants, SysUtils, Windows; procedure OpenXls(); procedure WriteXls(i,j: Integer;data: String); //将数据写入Excel procedure CloseXls( path: String );var wkBook: _WorkBook; wkSheet: _WorkSheet; LCID: Integer;implementationprocedure OpenXls();begin LCID := GetUserDefaultLCID(); VoiceCard.ExcelApp.Connect; wkBook := VoiceCard.ExcelApp.Workbooks.Add(EmptyParam, LCID); wkSheet := wkBook.Sheets[1] as _WorkSheet;end;procedure WriteXls(i,j: Integer;data: String);begin wkSheet.Cells.Item[i,j].value := data;end;procedure CloseXls( path: String );begin wkBook.Close(True, path, EmptyParam, LCID); VoiceCard.ExcelApp.Disconnect;end;end. SQL SERVER ----》EXECLvar sqll:string ;begintry ADOConnection14.Provider :='Microsoft.Jet.OLEDB.4.0;Data Source=C:\TEMP\TempXY.xls;Extended Properties=Excel 8.0' ; ADOConnection14.Connected := False ; ADOConnection14.Connected := True ; sqll :='SELECT * into SQLEXCEL FROM Zlyfpxy IN [ODBC] [ODBC;Driver=SQL Server;UID=;PWD=;Server=program.;DataBase=yj;]'; ADOConnection14.Execute(sqll ) ; Application.MessageBox('导出数据成功 !', PChar('数据导入导出提示'), MB_OK + MB_ICONINFORMATION + MB_TOPMOST);except Application.MessageBox('导出数据失败 !', PChar('数据导入导出提示'), MB_OK + MB_ICONINFORMATION + MB_TOPMOST);end;end; dbgrid如何动态更改显示? 老板要求:一个数据录入窗口,一个查询窗口实现MRP 主窗口设置问题 query查询某时间段内的记录,可是运行时有误,请高手进来看看呀,(有源码) 简单问题!!! 谁有reportbuilder的中文帮助文件 这里有哪一家公司要卖ERP源码吗? 将10进制转换成16进制的函数是什么啊? 菜单小问题 求解简单SQL: 关于messagebox的难题,高手,大虾指点. 用DEPHI如何做和qq界面一样的下拉菜单
procedure WriteXls(i,j: Integer;data: String); //将数据写入Excel
procedure CloseXls( path: String );var
wkBook: _WorkBook;
wkSheet: _WorkSheet;
LCID: Integer;implementationprocedure OpenXls();
begin
LCID := GetUserDefaultLCID();
VoiceCard.ExcelApp.Connect;
wkBook := VoiceCard.ExcelApp.Workbooks.Add(EmptyParam, LCID);
wkSheet := wkBook.Sheets[1] as _WorkSheet;
end;procedure WriteXls(i,j: Integer;data: String);
begin
wkSheet.Cells.Item[i,j].value := data;
end;procedure CloseXls( path: String );
begin
wkBook.Close(True, path, EmptyParam, LCID);
VoiceCard.ExcelApp.Disconnect;
end;end.
var
sqll:string ;
begin
try
ADOConnection14.Provider :='Microsoft.Jet.OLEDB.4.0;Data Source=C:\TEMP\TempXY.xls;Extended Properties=Excel 8.0' ;
ADOConnection14.Connected := False ;
ADOConnection14.Connected := True ;
sqll :='SELECT * into SQLEXCEL FROM Zlyfpxy IN [ODBC] [ODBC;Driver=SQL Server;UID=;PWD=;Server=program.;DataBase=yj;]';
ADOConnection14.Execute(sqll ) ;
Application.MessageBox('导出数据成功 !', PChar('数据导入导出提示'), MB_OK +
MB_ICONINFORMATION + MB_TOPMOST);
except
Application.MessageBox('导出数据失败 !', PChar('数据导入导出提示'), MB_OK +
MB_ICONINFORMATION + MB_TOPMOST);
end;
end;