Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Insert command with date
- Thread starter Dmarious
- Start date
Dmarious,
To insert the current date, you need to do something like:
Dim myDate : myDate = date
Dim sql
sql = "INSERT INTO TableName (Date) VALUES (#" & myDate & "#)"
ConnectionObject.Execute sql
That should do it.
Mise Le Meas,
Mighty
To insert the current date, you need to do something like:
Dim myDate : myDate = date
Dim sql
sql = "INSERT INTO TableName (Date) VALUES (#" & myDate & "#)"
ConnectionObject.Execute sql
That should do it.
Mise Le Meas,
Mighty
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
