用OLE技术太慢,可以把他导成TXT形式的文件, 当中用,分开 在EXDEL当中打开文本文件就行 例 var i:integer; str:string; begin query.close; query.sql.clear; query.sql.add('select * from table'); query.open; query.first; whiel not query.eof do begin str:=''; for i:=0 to query.fieldcount-1 str:=query.filds[i].asstring+','; 在这块加上写出一行到一个文本文件就行了 query.next; end;
EXEC master..xp_cmdshell 'bcp SettleDB.dbo.shanghu out c:\temp1.xls -c -q -S"GNETDATA/GNETDATA" -U"sa" -P""'/*********** 导入Excel
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions
2.程序:EXEC master..xp_cmdshell 'bcp SettleDB.dbo.shanghu out c:\temp1.xls -c -q -S"GNETDATA/GNETDATA" -U"sa" -P""'/*********** 导入Excel
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions
当中用,分开
在EXDEL当中打开文本文件就行
例
var
i:integer;
str:string;
begin
query.close;
query.sql.clear;
query.sql.add('select * from table');
query.open;
query.first;
whiel not query.eof do
begin
str:='';
for i:=0 to query.fieldcount-1
str:=query.filds[i].asstring+',';
在这块加上写出一行到一个文本文件就行了 query.next;
end;