Excel to Oracle

Hello. I requires a standalone Excel spreadsheet with a macro/module that can do this. 1: In the [login to view URL] attached, user fills out the defined data. 2: Hits a button to execute a query (either to INSERT data in trunc existing table, OR to DROP and recreate existing table) 3: The table to be created are stored as csv in the same folder. 4: the csv only has 6 columns ever. 5: The csv has data from row 2 6: the csv has Column Names that can be different BUT the datatype is the same as defined in CONTROL.xls. 7; This can be run for ALL CSV in the folder 7.1 OR only for ONE csv by specifying name in the cell B12. I tried to be simple in explanation, please ask questions if you like. DATABASE CONNECTION can be established like this (example cells used): Dim con As New [login to view URL] [login to view URL] "driver=microsoft odbc for oracle;uid=" + Range("A1") + ";pwd=" + Range("A2") + ";server=" + Range("A3") MsgBox "Connection OK" ----------------------------------------------------------------------------------------------