xls.dfm

xls2sql 将Microsoft的Excel文件导入MSSQL中

object Form1: TForm1
  Left = 183
  Top = 181
  Width = 544
  Height = 375
  Caption = #20135#21697#32467#26500#25991#20214#36716#25442
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  OnCreate = FormCreate
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 13
  object Label2: TLabel
    Left = 13
    Top = 11
    Width = 23
    Height = 13
    Caption = 'PNO'
  end
  object DBGrid1: TDBGrid
    Left = 0
    Top = 200
    Width = 536
    Height = 132
    DataSource = DataSource1
    TabOrder = 2
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
  end
  object DBGrid2: TDBGrid
    Left = 0
    Top = 38
    Width = 536
    Height = 147
    DataSource = DataSource2
    TabOrder = 3
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
  end
  object Button1: TButton
    Left = 230
    Top = 5
    Width = 41
    Height = 25
    Caption = #20889#20837
    TabOrder = 1
    OnClick = Button1Click
  end
  object Button2: TButton
    Left = 280
    Top = 5
    Width = 56
    Height = 25
    Caption = #20195#30721#25972#29702
    TabOrder = 4
    OnClick = Button2Click
  end
  object Edit1: TEdit
    Left = 43
    Top = 7
    Width = 163
    Height = 21
    CharCase = ecUpperCase
    TabOrder = 0
    OnChange = Edit1Change
    OnExit = Edit1Exit
  end
  object ADOConnection1: TADOConnection
    ConnectionString = 
      'Provider=MSDASQL.1;Persist Security Info=False;Connect Timeout=1' +
      '5;Extended Properties="DBQ=C:\whdsxls.xls;DefaultDir=c:\;Driver=' +
      '{Microsoft Excel Driver (*.xls)};DriverId=790;FIL=excel 8.0;FILE' +
      'DSN=C:\whdsxls.dsn;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=' +
      '5;ReadOnly=1;SafeTransactions=0;Threads=3;UID=admin;UserCommitSy' +
      'nc=Yes;";Locale Identifier=2052'
    LoginPrompt = False
    Provider = 'MSDASQL.1'
    Left = 183
    Top = 131
  end
  object ADOQuery1: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from [sheet1$]')
    Left = 255
    Top = 131
  end
  object DataSource1: TDataSource
    DataSet = ADOQuery1
    Left = 215
    Top = 131
  end
  object whdb: TDatabase
    AliasName = 'whdb'
    DatabaseName = 'wh_dba'
    KeepConnection = False
    LoginPrompt = False
    Params.Strings = (
      'USER NAME=sa'
      'PASSWORD=')
    SessionName = 'Default'
    Left = 95
    Top = 107
  end
  object qu_tb: TQuery
    AutoCalcFields = False
    DatabaseName = 'wh_dba'
    SessionName = 'Default'
    Left = 131
    Top = 130
  end
  object DataSource2: TDataSource
    DataSet = qu_tb
    Left = 153
    Top = 131
  end
  object OpenDialog1: TOpenDialog
    Filter = 'Excel file(*.xls)|*.xls'
    Left = 296
    Top = 133
  end
  object tb_tran: TQuery
    AutoCalcFields = False
    DatabaseName = 'wh_dba'
    SessionName = 'Default'
    Left = 211
    Top = 100
  end
end