u_dbtrans1.~pas

数据导入导出

unit U_dbtrans1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, bsSkinCtrls, StdCtrls, DB, ADODB, DBTables;

type

  Tdbtrans = class(TForm)
    fromaccessquery_1: TADOQuery;
    fromaccessquery_3: TADOQuery;
    fromaccessquery_2: TADOQuery;
    GroupBox1: TGroupBox;
    GroupBox2: TGroupBox;
    Button1: TButton;
    Button2: TButton;
    bsSkinGauge1: TbsSkinGauge;
    Button3: TButton;
    Memo1: TMemo;
    tosqlserver: TADOQuery;
    tosqlserverB: TADOQuery;
    bsSkinGauge2: TbsSkinGauge;
    Table1: TTable;
    OpenDialog1: TOpenDialog;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);

  private
    procedure ODBCcreate;
  
    { Private declarations }
  public

    { Public declarations }
  end;

var
  dbtrans: Tdbtrans;
var pathname:string;

implementation    //注册表单元文件
  uses U_dbTread,registry,u_checkaccess,u_dmd;////注册表单元文件;//引用U_CHECKACCESS单元中PATHNAME变量
{$R *.dfm}

procedure Tdbtrans.Button1Click(Sender: TObject);


begin



      mydbthread.create(false);
       




      
end;

procedure Tdbtrans.Button2Click(Sender: TObject);
begin

 close;

end;



procedure Tdbtrans.Button3Click(Sender: TObject);
begin

  if opendialog1.Execute then
   begin
    pathname:=opendialog1.FileName;
    dbtrans.ODBCcreate;
   end;

end;

procedure Tdbtrans.ODBCcreate;//动态建立ODBC数据源
var
  reg:TRegistry;
  data:array[0..0]of byte;
begin
  reg:=TRegistry.Create;
  with reg do
  begin
    Rootkey:=HKEY_CURRENT_USER;
    if OpenKey('Software\ODBC\ODBC.INI\ODBC Data Sources',True) then
    begin
    WriteString('XSJ','Microsoft Access Driver(*.mdb)');
    end
    else
    begin
      showmessage('载入失败,无法进行数据库转换');
      exit;
    end;
    CloseKey;
    if OpenKey('Software\ODBC\ODBC.INI\XSJ',True) then
    begin
      WriteString('DBQ',pathname);
     // WriteString('description','时势软件');
      WriteString('Driver','C:\WINDOWS\system32\odbcjt32.dll');
      WriteInteger('DriverId',25);
      WriteString('FIL','MS Access;');
      WriteInteger('SafeTransactions',0);
      WriteString('UID','');
      Data[0]:=0;
     // WriteBinaryData('Exclusive',Data,1);
     // WriteBinaryData('ReadOnly',Data,1);
    end
    else
    begin
      showmessage('载入失败,无法进行数据库转换');
      exit;
    end;
    CloseKey;
    if OpenKey('Software\ODBC\ODBC.INI\XSJ\Engines\Jet',True) then
    begin
     WriteString('ImplicitCommitSync','');
     WriteInteger('MaxBufferSize',2048);
     WriteInteger('PageTimeout',5);
     WriteInteger('Threads',3);
     WriteString('UserCommitSync','Yes');
    end
    else
    begin
      showmessage('载入失败,无法进行数据库转换');
      exit;
    end;
    CloseKey;
    showmessage('载入成功');
    free;
    end;

end;


end.