unit1.pas

将ACCESS数据库表导出为word、excel、txt、xml、dbf等格式。

unit Unit1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, ADODB, StdCtrls, Grids, DBGrids, ExportDS, SME2Cell, SME2PDF,
  SME2OLE, SME2DBF, SME2TXT, SME2XML;

type
  TForm1 = class(TForm)
    Button1: TButton;
    Button2: TButton;
    ADOConnection1: TADOConnection;
    ADOTable1: TADOTable;
    OpenDialog1: TOpenDialog;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    ListBox1: TListBox;
    SMExportToAccess1: TSMExportToAccess;
    SaveDialog1: TSaveDialog;
    Label1: TLabel;
    Label2: TLabel;
    DBF_RadioButton: TRadioButton;
    MDB_RadioButton: TRadioButton;
    Txt_RadioButton: TRadioButton;
    SMExportToText1: TSMExportToText;
    SMExportToDBF1: TSMExportToDBF;
    SMExportToExcel1: TSMExportToExcel;
    excle_RadioButton: TRadioButton;
    SMExportToXML1: TSMExportToXML;
    Xml_RadioButton: TRadioButton;
    SMExportToWord: TSMExportToWord;
    word_RadioButton: TRadioButton;
    procedure Button1Click(Sender: TObject);
    procedure ListBox1DblClick(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
var
 connstr:string;
begin
 if form1.OpenDialog1.Execute then
  begin
     connstr:='Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=';
     connstr:=connstr+form1.OpenDialog1.FileName;
     connstr:=connstr+'Persist Security Info=False';
     form1.ADOConnection1.Connected:=True;
     form1.ADOConnection1.GetTableNames(ListBox1.Items,False);
   end;
end;

procedure TForm1.ListBox1DblClick(Sender: TObject);
var
 i:Integer;
begin
  for i:=0 to (listBox1.Items.Count-1) do
   if listBox1.Selected[i] then
    begin
     form1.ADOTable1.Active:=false;
     form1.ADOTable1.TableName:=listbox1.Items[i];
     form1.SMExportToAccess1.TableName:=listbox1.Items[i];
     form1.ADOTable1.Active:=True;
    end;
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
  IF form1.DBF_RadioButton.Checked THEN
   BEGIN
     form1.SaveDialog1.FilterIndex:=1;
   end;
   if form1.MDB_RadioButton.Checked then
    begin
      form1.SaveDialog1.FilterIndex:=2;
    end;
    if form1.Txt_RadioButton.Checked then
     begin
       form1.SaveDialog1.FilterIndex:=3;
     end;
     if form1.excle_RadioButton.Checked then
     begin
       form1.SaveDialog1.FilterIndex:=4;
     end;
    if form1.xml_RadioButton.Checked then
     begin
       form1.SaveDialog1.FilterIndex:=5;
     end;
    if form1.word_RadioButton.Checked then
     begin
       form1.SaveDialog1.FilterIndex:=6;
     end;
  IF FORM1.SaveDialog1.Execute THEN
   begin
    if form1.DBF_RadioButton.Checked then
     begin
      form1.SMExportToDBF1.FileName:=form1.SaveDialog1.FileName;
      form1.SMExportToDBF1.Execute;
     end;
     if form1.MDB_RadioButton.Checked then
      begin
       form1.SMExportToAccess1.FileName:=form1.SaveDialog1.FileName;
       form1.SMExportToAccess1.Execute;
      end;
     if form1.Txt_RadioButton.Checked then
       begin
         form1.SMExportToText1.FileName:=form1.SaveDialog1.FileName;
         form1.SMExportToText1.Execute;
       end;
     if form1.excle_RadioButton.Checked then
       begin
         form1.SMExportToExcel1.FileName:=form1.SaveDialog1.FileName;
         form1.SMExportToExcel1.Execute;
       end;
     if form1.xml_RadioButton.Checked then
       begin
         form1.SMExportToXML1.FileName:=form1.SaveDialog1.FileName;
         form1.SMExportToXML1.Execute;
       end;
     if form1.word_RadioButton.Checked then
       begin
         form1.SMExportToWord.FileName:=form1.SaveDialog1.FileName;
         form1.SMExportToWord.Execute;
       end;
   end;
end;

end.