datainputfomatfile.frm

适合乡镇供电所使用电费处理系统v3 软件

VERSION 5.00
Begin VB.Form DataInputFomatFile 
   Caption         =   "Form1"
   ClientHeight    =   3195
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   4680
   LinkTopic       =   "Form1"
   ScaleHeight     =   3195
   ScaleWidth      =   4680
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton Command4 
      Caption         =   "导出为Excel文件"
      Height          =   495
      Left            =   1920
      TabIndex        =   3
      Top             =   720
      Width           =   1215
   End
   Begin VB.CommandButton Command3 
      Caption         =   "导出为HTML文件"
      Height          =   495
      Left            =   360
      TabIndex        =   2
      Top             =   2160
      Width           =   1215
   End
   Begin VB.CommandButton Command2 
      Caption         =   "导出为TXT文件"
      Height          =   495
      Left            =   360
      TabIndex        =   1
      Top             =   1440
      Width           =   1215
   End
   Begin VB.CommandButton Command1 
      Caption         =   "导出为DBase文件"
      Height          =   495
      Left            =   360
      TabIndex        =   0
      Top             =   720
      Width           =   1215
   End
   Begin VB.Data Data1 
      Caption         =   "Data1"
      Connect         =   "Access"
      DatabaseName    =   ""
      DefaultCursorType=   0  '缺省游标
      DefaultType     =   2  '使用 ODBC
      Exclusive       =   0   'False
      Height          =   345
      Left            =   2280
      Options         =   0
      ReadOnly        =   0   'False
      RecordsetType   =   1  'Dynaset
      RecordSource    =   ""
      Top             =   2760
      Width           =   1155
   End
End
Attribute VB_Name = "DataInputFomatFile"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim db As Database
'输出到dBase文件
Private Sub Command1_Click()
Command1.Enabled = False
db.Execute "SELECT * INTO [dBase III;DATABASE=C:\].[authors.DBF] FROM [用户档案]"
Command1.Enabled = True
End Sub
'输出到Text文件
Private Sub Command2_Click()
Command2.Enabled = False
db.Execute "SELECT * INTO [Text;DATABASE=C:\].[authors.TXT] FROM [用户档案]"
Command2.Enabled = True
End Sub
'输出到Html文件
Private Sub Command3_Click()
Command1.Enabled = False
db.Execute "SELECT * INTO [HTML Export;DATABASE=C:\].[authors.HTM] FROM [用户档案]"
Command1.Enabled = True
End Sub
'输出到Excel文件
Private Sub Command4_Click()
Command1.Enabled = False
db.Execute "SELECT 用户表码,用户名称,本期示数,上期示数,本次电量,合计电量,电价,本次电费,合计电费 INTO [Excel 8.0;DATABASE=C:\200103.XLS].[用户档案] FROM [用户档案]"
Command1.Enabled = True
End Sub

Private Sub Form_Load()
Command1.Enabled = False
'Set db = Workspaces(0).OpenDatabase("C:\Program Files\Microsoft Visual Studio\VB98\biblio.mdb")
Set db = Workspaces(0).OpenDatabase("d:\nd2000\data\eletricity.mdb")
Command1.Enabled = True
End Sub