S
Santiago
Hey guys,
I'm trying to update some data in an Access DB from Excel using ADO & SQL.
I'd like to update some fields with a defined criteria using the WHERE clause
in SQL, but dates seem not to work...
I use the SQL string like:
UPDATE
SET [field1] = 'aa', [field2] = #15/01/2005# etc... _
WHERE [field3] = 'bla' AND [field4] = #01/01/2005#
I believe that the problem is the date I'm filtering... I copied the whole
SQL string into access and did not work. But if I remove the date criteria
seems to work.
I appreciate your help.
Thanks & Bregards
Santiago
I'm trying to update some data in an Access DB from Excel using ADO & SQL.
I'd like to update some fields with a defined criteria using the WHERE clause
in SQL, but dates seem not to work...
I use the SQL string like:
UPDATE
WHERE [field3] = 'bla' AND [field4] = #01/01/2005#
I believe that the problem is the date I'm filtering... I copied the whole
SQL string into access and did not work. But if I remove the date criteria
seems to work.
I appreciate your help.
Thanks & Bregards
Santiago