xls.dfm

xls2sql 将Microsoft的Excel文件导入MSSQL中

object Form1: TForm1
  Left = 32
  Top = 62
  Width = 755
  Height = 458
  Caption = #38646#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
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 13
  object Label1: TLabel
    Left = 32
    Top = 11
    Width = 52
    Height = 13
    Caption = #19978#32423#31867#22411'id'
  end
  object Label4: TLabel
    Left = 36
    Top = 38
    Width = 199
    Height = 13
    Caption = #27880#65306#24403#20195#30721#20026#31354#26102#20195#30721#35774#32622#20026#22270#21495#21069'20'#20301
  end
  object DBGrid1: TDBGrid
    Left = 5
    Top = 265
    Width = 733
    Height = 149
    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 = 5
    Top = 68
    Width = 733
    Height = 189
    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 = 208
    Top = 6
    Width = 75
    Height = 25
    Caption = #35835#20837
    TabOrder = 1
    OnClick = Button1Click
  end
  object Edit1: TEdit
    Left = 98
    Top = 7
    Width = 73
    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 = 321
    Top = 235
  end
  object ADOQuery1: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from [sheet1$]')
    Left = 393
    Top = 235
  end
  object DataSource1: TDataSource
    DataSet = ADOQuery1
    Left = 353
    Top = 235
  end
  object whdb: TDatabase
    AliasName = 'whdb'
    DatabaseName = 'wh_dba'
    LoginPrompt = False
    Params.Strings = (
      'user name=sa'
      'password=')
    SessionName = 'Default'
    Left = 217
    Top = 227
  end
  object qu_tb: TQuery
    AutoRefresh = True
    DatabaseName = 'wh_dba'
    SessionName = 'Default'
    SQL.Strings = (
      'select * from material where mmx<>1 order by mid')
    Left = 261
    Top = 234
  end
  object DataSource2: TDataSource
    DataSet = qu_tb
    Left = 291
    Top = 235
  end
  object OpenDialog1: TOpenDialog
    Filter = 'Excel file(*.xls)|*.xls'
    Left = 296
    Top = 202
  end
  object Qu_temp: TQuery
    AutoRefresh = True
    DatabaseName = 'wh_dba'
    SessionName = 'Default'
    SQL.Strings = (
      '')
    Left = 261
    Top = 202
  end
end