xls.dfm

xls2sql 将Microsoft的Excel文件导入MSSQL中

object Form1: TForm1
  Left = 182
  Top = 189
  Width = 550
  Height = 375
  Caption = #20135#21697#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
  PixelsPerInch = 96
  TextHeight = 13
  object Label1: TLabel
    Left = 6
    Top = 11
    Width = 40
    Height = 13
    Caption = #19978#32423'PID'
  end
  object Label2: TLabel
    Left = 140
    Top = 11
    Width = 45
    Height = 13
    Caption = #19978#32423'PNO'
  end
  object Label3: TLabel
    Left = 315
    Top = 11
    Width = 68
    Height = 13
    Caption = #36215#22987#24207#21495'[000]'
  end
  object Label4: TLabel
    Left = 443
    Top = 11
    Width = 44
    Height = 13
    Caption = #20135#21697#32423#21035
  end
  object DBGrid1: TDBGrid
    Left = 3
    Top = 194
    Width = 528
    Height = 132
    DataSource = DataSource1
    TabOrder = 5
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
  end
  object DBGrid2: TDBGrid
    Left = 0
    Top = 72
    Width = 536
    Height = 113
    DataSource = DataSource2
    TabOrder = 6
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
  end
  object Button1: TButton
    Left = 392
    Top = 41
    Width = 123
    Height = 25
    Caption = #20889#20837
    TabOrder = 4
    OnClick = Button1Click
  end
  object Edit1: TEdit
    Left = 51
    Top = 7
    Width = 80
    Height = 21
    TabOrder = 0
  end
  object Edit2: TEdit
    Left = 189
    Top = 7
    Width = 112
    Height = 21
    TabOrder = 1
  end
  object Edit3: TEdit
    Left = 386
    Top = 7
    Width = 48
    Height = 21
    TabOrder = 2
  end
  object Edit4: TEdit
    Left = 493
    Top = 7
    Width = 19
    Height = 21
    TabOrder = 3
    Text = '3'
  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 = 256
    Top = 236
  end
  object ADOQuery1: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from [sheet1$]')
    Left = 294
    Top = 236
  end
  object DataSource1: TDataSource
    DataSet = ADOQuery1
    Left = 332
    Top = 236
  end
  object whdb: TDatabase
    AliasName = 'whdb'
    DatabaseName = 'wh_dba'
    LoginPrompt = False
    Params.Strings = (
      'username=sa'
      'password=james')
    SessionName = 'Default'
    Left = 143
    Top = 236
  end
  object qu_tb: TQuery
    AutoRefresh = True
    DatabaseName = 'wh_dba'
    SessionName = 'Default'
    SQL.Strings = (
      'select * from product order by pid')
    Left = 181
    Top = 235
  end
  object DataSource2: TDataSource
    DataSet = qu_tb
    Left = 219
    Top = 236
  end
  object OpenDialog1: TOpenDialog
    Filter = 'Excel file(*.xls)|*.xls'
    Left = 377
    Top = 236
  end
end