CODEWITHSUNDEEP
vbams-access
user1940530
user1940530

Reputation: 17

Delete all all except one column in access 2007 using delete query

I am not familiar to SQL script in VBA Access script. Can you tell me what to do to delete data in all the column except one? Thank you.

Upvotes: 0

Views: 585

Answers (1)

HansUp
HansUp

Reputation: 97101

When you say delete, if you mean replace column values with Null, you can do that with an UPDATE query.

UPDATE YourTable
SET
    ColumnA = Null,
    ColumnB = Null

Do that for all the columns whose data you wish to delete.

If that's not what you had in mind, please give us more detailed information to help us understand what you want.

Upvotes: 1

Related Questions