Insert date and time field into MS Access with SQL
INSERT INTO t_import (netid, What, Where, Date, Time, Computer, Paper_size,
File_size, #pages, Charge, Balance)
VALUES ('" & A(0) & "','" & A(1) & "','" & A(2) & "',#" & dateVal & "#,#" &
timeVal & "#,'" & A(5) & "','" & A(8) & "','" & A(10) & "','" & A(11) & "',"
& A(12) & "," & A(13) & ")"
Basically, I have to handle the dateVal and the timeVal variables to
correctly insert them into an MS Access Short Date and Short Time,
respectively.
How do I do this?
Thanks,
Scott