EXCEL VBA to insert data in Oracle Database

[audiorij]

Ok, my intention is to create an excel userform that takes input and inserts the data in an oracle database tabel. But first I am just trying to get a simple macro to work at inserting some data into the database. I believe the connection is fine, it doesn't give any errors there. But it gives an error saying there is a missing 'select' statement.

SOIDOWNTIME2 is the tabe, the columns are (SDT_ID, SDT_Date, SDT_Shift, SDT_Tool, SDT_Output, SDT_Goal, SDT_Oper, SDT_StartDown, SDT_EndDown, SDT_Duration, SDT_Comment, SDT_Type)

Right now I am just trying to add text to the STD_Comment column. Any help is appreciated. I've actually tried multiple macros that i have found on the web and I alwasy end up with the missing select statement.

I couldn't post the code... SQL blocked. So it is attached.