frmmain.frm

Converting CSV Files to SQL using VB6

VERSION 5.00
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "comdlg32.ocx"
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "msflxgrd.ocx"
Begin VB.Form frmMain 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "Convert CSV to SQL INSERTS"
   ClientHeight    =   7875
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   8700
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   7875
   ScaleWidth      =   8700
   StartUpPosition =   3  'Windows Default
   Begin MSComDlg.CommonDialog CommonDialog1 
      Left            =   780
      Top             =   5250
      _ExtentX        =   847
      _ExtentY        =   847
      _Version        =   393216
   End
   Begin VB.CommandButton cmdOk 
      Caption         =   "Process"
      Height          =   405
      Left            =   6900
      TabIndex        =   6
      Top             =   7350
      Width           =   1725
   End
   Begin VB.Frame Frame3 
      Caption         =   "3. Insert INTO fields (and datatypes)"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   8.25
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   4035
      Left            =   2430
      TabIndex        =   4
      Top             =   2940
      Width           =   6165
      Begin VB.ComboBox cboDataTypes 
         Height          =   315
         Left            =   4260
         Style           =   2  'Dropdown List
         TabIndex        =   20
         Top             =   2160
         Width           =   1755
      End
      Begin VB.CommandButton btnRemoveField 
         Caption         =   "Remove Field"
         Height          =   345
         Left            =   4290
         TabIndex        =   19
         Top             =   3210
         Width           =   1725
      End
      Begin VB.CommandButton btnAddField 
         Caption         =   "Add Field"
         Height          =   345
         Left            =   4290
         TabIndex        =   18
         Top             =   2790
         Width           =   1725
      End
      Begin MSFlexGridLib.MSFlexGrid MSFGFields 
         Height          =   2175
         Left            =   150
         TabIndex        =   17
         Top             =   1440
         Width           =   3945
         _ExtentX        =   6959
         _ExtentY        =   3836
         _Version        =   393216
         FixedCols       =   0
         FocusRect       =   0
         HighLight       =   2
         SelectionMode   =   1
         AllowUserResizing=   1
      End
      Begin VB.TextBox txtFieldNames 
         Height          =   345
         Left            =   4260
         TabIndex        =   10
         Top             =   1440
         Width           =   1755
      End
      Begin VB.Label lblSelectedField 
         Caption         =   "No Fields Selected"
         ForeColor       =   &H00808080&
         Height          =   225
         Left            =   150
         TabIndex        =   23
         Top             =   3660
         Width           =   5865
      End
      Begin VB.Label Label3 
         Caption         =   $"frmMain.frx":0000
         Height          =   735
         Left            =   210
         TabIndex        =   21
         Top             =   420
         Width           =   5805
      End
      Begin VB.Label Label1 
         Caption         =   "Fields and Datatypes"
         Height          =   465
         Left            =   180
         TabIndex        =   16
         Top             =   1230
         Width           =   2025
      End
      Begin VB.Label label8 
         Caption         =   "Field Data Type"
         Height          =   255
         Left            =   4260
         TabIndex        =   12
         Top             =   1920
         Width           =   1515
      End
      Begin VB.Label Label7 
         Caption         =   "Field Name"
         Height          =   345
         Left            =   4260
         TabIndex        =   11
         Top             =   1230
         Width           =   1185
      End
   End
   Begin VB.Frame Frame2 
      Caption         =   "1. Source File"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   8.25
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   2625
      Left            =   90
      TabIndex        =   3
      Top             =   210
      Width           =   8505
      Begin VB.CommandButton cmdLocate 
         Caption         =   "Locate..."
         Height          =   345
         Left            =   6870
         TabIndex        =   13
         Top             =   1200
         Width           =   1245
      End
      Begin VB.TextBox txtExportFile 
         Height          =   345
         Left            =   300
         Locked          =   -1  'True
         TabIndex        =   8
         Top             =   1980
         Width           =   6465
      End
      Begin VB.TextBox txtImportFile 
         Height          =   345
         Left            =   300
         Locked          =   -1  'True
         TabIndex        =   5
         Top             =   1200
         Width           =   6465
      End
      Begin VB.Label Label10 
         Caption         =   $"frmMain.frx":00FB
         Height          =   585
         Left            =   300
         TabIndex        =   24
         Top             =   390
         Width           =   7785
      End
      Begin VB.Label Label6 
         Caption         =   "Export File"
         Height          =   345
         Left            =   300
         TabIndex        =   9
         Top             =   1740
         Width           =   1845
      End
      Begin VB.Label Label5 
         Caption         =   "Source File"
         Height          =   345
         Left            =   300
         TabIndex        =   7
         Top             =   960
         Width           =   1845
      End
   End
   Begin VB.Frame Frame1 
      Caption         =   "2. Oracle Login"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   8.25
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   4035
      Left            =   90
      TabIndex        =   0
      Top             =   2940
      Width           =   2265
      Begin VB.TextBox txtTableName 
         Height          =   345
         Left            =   240
         TabIndex        =   14
         Top             =   1440
         Width           =   1695
      End
      Begin VB.TextBox txtUser 
         Height          =   345
         Left            =   240
         TabIndex        =   2
         Top             =   2160
         Width           =   1695
      End
      Begin VB.Label Label9 
         Caption         =   "Supply the table name.  If applicable, please provide a Schema name."
         Height          =   645
         Left            =   210
         TabIndex        =   22
         Top             =   420
         Width           =   1905
      End
      Begin VB.Label Label4 
         Caption         =   "Table Name"
         Height          =   345
         Left            =   240
         TabIndex        =   15
         Top             =   1230
         Width           =   1785
      End
      Begin VB.Label Label2 
         Caption         =   "Oracle User (Schema)"
         Height          =   285
         Left            =   270
         TabIndex        =   1
         Top             =   1950
         Width           =   1785
      End
   End
End
Attribute VB_Name = "frmMain"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit

Private fso As Scripting.FileSystemObject


Private Sub btnAddField_Click()

    If txtFieldNames.Text <> "" And cboDataTypes.Text <> "" Then
    
        MSFGFields.AddItem txtFieldNames.Text & vbTab & cboDataTypes.Text
        txtFieldNames.Text = ""
        cboDataTypes.ListIndex = -1
    
    Else