Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Is it possible to delete all of a column's data in access without deleting the field?

share|improve this question

2 Answers 2

up vote 1 down vote accepted

Run a query. Here's the SQL, substitute in the actual values:

Update [Table Name] Set [Field Name] = null
share|improve this answer
Or you can go into the interactive table data editor and just highlight all the rows and hit delete; that should set them to null (I think) or their default value if nulls aren't allowed. –  allquixotic Sep 19 '12 at 19:49
Dunno why I didn't think of that, I've become too reliant on the GUI lately. –  Austin Davis Sep 19 '12 at 20:32
@allquixotic FYI: Doing that with a table actually asks if you want to delete the fields (which means remove them from the table all together). Doing the same thing in a query just has no affect. –  Daniel Cook Sep 19 '12 at 21:23

Just select the column and hit option H to replace data. Put and asterisk in the first box and leave the second box blank. Simplest way to do it.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.