I need to write a SQL from VBA of Excel to insert data into Access database.
e.g.
Dim strSQL as String
Dim itemDate as String // user will input data that is a valid date format. such as 29/8/2007
Dim conn as new adodb.Connection
strSQL = "INSERT INTO TEST_TB (ITEM_ID, ITEM_DATE)" & _
" VALUES ('item001', '" & FormatDateTime(itemDate) & "' );"
conn.execute(strSQL)
-----
But error will appear when the user no input item date
(becuase the application is allowed no input for item date fields.
* ITEM_ID is TEXT type in database
ITEM_DATE is DATE type in database
<message edited by Kitshing on Wednesday, August 29, 2007 4:31 AM>