xls.dfm

xls2sql 将Microsoft的Excel文件导入MSSQL中

object Form1: TForm1
  Left = 158
  Top = 116
  Width = 544
  Height = 375
  Caption = #37096#20214#24211#35835#20837
  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 = 10
    Top = 11
    Width = 52
    Height = 13
    Caption = #19978#32423#31867#22411'id'
  end
  object Label2: TLabel
    Left = 156
    Top = 11
    Width = 84
    Height = 13
    Caption = 'mid'#36215#22987#24207#21495'[000]'
  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 = 335
    Top = 5
    Width = 67
    Height = 25
    Caption = #20889#20837
    TabOrder = 1
    OnClick = Button1Click
  end
  object Edit1: TEdit
    Left = 76
    Top = 7
    Width = 73
    Height = 21
    TabOrder = 0
  end
  object Edit2: TEdit
    Left = 246
    Top = 7
    Width = 73
    Height = 21
    TabOrder = 4
  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 = 321
    Top = 237
  end
  object ADOQuery1: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from [sheet1$]')
    Left = 393
    Top = 237
  end
  object DataSource1: TDataSource
    DataSet = ADOQuery1
    Left = 353
    Top = 237
  end
  object whdb: TDatabase
    AliasName = 'whdb'
    DatabaseName = 'wh_dba'
    LoginPrompt = False
    Params.Strings = (
      'username=sa'
      'password=james')
    SessionName = 'Default'
    Left = 233
    Top = 237
  end
  object qu_tb: TQuery
    AutoRefresh = True
    DatabaseName = 'wh_dba'
    SessionName = 'Default'
    SQL.Strings = (
      'select * from material order by mid')
    Left = 261
    Top = 236
  end
  object DataSource2: TDataSource
    DataSet = qu_tb
    Left = 291
    Top = 237
  end
  object OpenDialog1: TOpenDialog
    Filter = 'Excel file(*.xls)|*.xls'
    Left = 431
    Top = 237
  end
end