Writing same thing to a range of columns - best method?

[Middlemarch]

I'd like to clear columns 10-22 in my table. Either null or "".
Would you just loop through writing to each field individually - or is there a better way, ? ?



Thanks.

[Middlemarch]

From Google I found

UPDATE table
SET Newvalue
WHERE criteria

If table is table1, newvalue is "", criteria is id = 22 and Fieldnames Like *Wk*

Is that do-able in an update query?
Thanks.

[davegri]

Update query will work. If you are updating the entire table (all records) you won't need criteria.

[John_G]

That is not the correct syntax for an Update query. It should be:

UPDATE table
SET Field1 = Newvalue1. Field2 = newvalue2, ...
WHERE criteria

The criteria specifies which records to update, not which fields to update. In your case, you don't need criteria.

It will be much easier if you use the query design grid, rather than writing the SQL manually.

[Thompyt]

I used this on my excel code:

wkSheetC.Columns.Range("A:C,E:G,I:M").Delete