把EXCEL数据导入ACCESS中,有什么好方法,急啊!! 如文章标题 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 给你一个access和excel互相导入导出的例子参考一下unit U_AccExcel;interfaceuses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls, ExtCtrls, DB, ADODB;type TExcelandAccessFrm = class(TForm) AOpenDialog: TOpenDialog; EOpenDialog: TOpenDialog; Excel: TLabeledEdit; E: TLabeledEdit; Button1: TButton; Access: TLabeledEdit; A: TLabeledEdit; Button2: TButton; AEBtn: TButton; EABtn: TButton; CloseBtn: TButton; ADO: TADOConnection; procedure Button1Click(Sender: TObject); procedure Button2Click(Sender: TObject); procedure CloseBtnClick(Sender: TObject); procedure EABtnClick(Sender: TObject); procedure AEBtnClick(Sender: TObject); private { Private declarations } public { Public declarations } end;var ExcelandAccessFrm: TExcelandAccessFrm;implementation{$R *.dfm}procedure TExcelandAccessFrm.Button1Click(Sender: TObject);begin if EOpenDialog.Execute then Excel.Text := EOpenDialog.FileName;end;procedure TExcelandAccessFrm.Button2Click(Sender: TObject);begin if AOpenDialog.Execute then Access.Text := AOpenDialog.FileName;end;procedure TExcelandAccessFrm.CloseBtnClick(Sender: TObject);begin Close;end;procedure TExcelandAccessFrm.EABtnClick(Sender: TObject);var SQLStr:string;begin if ((Excel.Text<>'')and(Access.Text<>'')and(e.Text<>'')and(a.Text<>'')) then begin ADO.Connected:=false; ADO.ConnectionString:= 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+access.Text+';' +'Persist Security Info=False'; SQLStr:='select * into '+a.Text+' FROM [excel 8.0;database='+excel.Text+'].['+e.Text+'$]'; ADO.Execute(SQLStr); ADO.Connected:=true; Application.MessageBox('数据转换成功','系统提示'); endelse begin Application.MessageBox('请输入完整数据','系统提示'); end;end;procedure TExcelandAccessFrm.AEBtnClick(Sender: TObject);var SQLStr:string;begin if ((Excel.Text<>'')and(Access.Text<>'')and(e.Text<>'')and(a.Text<>'')) then begin ADO.Connected:=false; ADO.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+access.Text+';' +'Persist Security Info=False'; SQLStr:='Select* Into '+e.Text+' In "'+Excel.Text+'" "Excel 8.0;" From '+a.Text; ADO.Execute(SQLStr); ADO.Connected:=true; Application.MessageBox('数据转换成功','系统提示'); endelse begin Application.MessageBox('请输入完整数据','系统提示'); end;end;end. select * into <table name> from [excel 8.0;database=<filename>].[<sheetname>$] 为什么用idftp get() 下载一个文件后修改日期被改成了系统当前的日期? 大版,小版,高手,走过路过,不要错过! 如何实现修改系统对话框?(打开,保存) 怎样限制DBGridEH只能选择当前行 怎么设置TidHTTP的TimeOut? 关于DataModule问题...在线等待,谢谢 怎样获得系统的日期和时间? MRP II程序设计意见征评(全部分数) 找一份兼职的程序员工作 Delphi程序员转型要注意什么? delphi 怎样定时执行任务 如何让SHAPE能够显示在GRID上面?
参考一下unit U_AccExcel;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, ExtCtrls, DB, ADODB;type
TExcelandAccessFrm = class(TForm)
AOpenDialog: TOpenDialog;
EOpenDialog: TOpenDialog;
Excel: TLabeledEdit;
E: TLabeledEdit;
Button1: TButton;
Access: TLabeledEdit;
A: TLabeledEdit;
Button2: TButton;
AEBtn: TButton;
EABtn: TButton;
CloseBtn: TButton;
ADO: TADOConnection;
procedure Button1Click(Sender: TObject);
procedure Button2Click(Sender: TObject);
procedure CloseBtnClick(Sender: TObject);
procedure EABtnClick(Sender: TObject);
procedure AEBtnClick(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
ExcelandAccessFrm: TExcelandAccessFrm;implementation{$R *.dfm}procedure TExcelandAccessFrm.Button1Click(Sender: TObject);
begin
if EOpenDialog.Execute then Excel.Text := EOpenDialog.FileName;
end;procedure TExcelandAccessFrm.Button2Click(Sender: TObject);
begin
if AOpenDialog.Execute then Access.Text := AOpenDialog.FileName;
end;procedure TExcelandAccessFrm.CloseBtnClick(Sender: TObject);
begin
Close;
end;procedure TExcelandAccessFrm.EABtnClick(Sender: TObject);
var
SQLStr:string;
begin
if ((Excel.Text<>'')and(Access.Text<>'')and(e.Text<>'')and(a.Text<>'')) then
begin ADO.Connected:=false;
ADO.ConnectionString:=
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+access.Text+';'
+'Persist Security Info=False';
SQLStr:='select * into '+a.Text+' FROM [excel 8.0;database='+excel.Text+'].['+e.Text+'$]';
ADO.Execute(SQLStr);
ADO.Connected:=true;
Application.MessageBox('数据转换成功','系统提示');
end
else
begin
Application.MessageBox('请输入完整数据','系统提示');
end;
end;procedure TExcelandAccessFrm.AEBtnClick(Sender: TObject);
var
SQLStr:string;
begin
if ((Excel.Text<>'')and(Access.Text<>'')and(e.Text<>'')and(a.Text<>'')) then
begin
ADO.Connected:=false;
ADO.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+access.Text+';'
+'Persist Security Info=False';
SQLStr:='Select* Into '+e.Text+' In "'+Excel.Text+'" "Excel 8.0;" From '+a.Text;
ADO.Execute(SQLStr);
ADO.Connected:=true;
Application.MessageBox('数据转换成功','系统提示');
end
else
begin
Application.MessageBox('请输入完整数据','系统提示');
end;
end;end.