in my sql i use
...,#" & MIA_DATA & "#,...
but
'" & MIA_DATA & "'
it's the same?
note:
MIA_DATA is dimensioned as Date
dubt on insert
-
HansV
- Administrator
- Posts: 78415
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: dubt on insert
If the table resides in an Access database, you should use
But if the table resides in a SQL Server database, you should use
Code: Select all
...,#" & Format(MIA_DATA, "yyyy-mm-dd") & "#,...
Code: Select all
...,'" & Format(MIA_DATA, "yyyy-mm-dd") & "',...Best wishes,
Hans
Hans