Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
up vote 2 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 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
It's a little more than what user348469 said, for example you have to choose current field for the "Look in" parameter but his answer definitely helped me as I needed to replace info in filtered Datasheet view – user408341 Jan 13 '15 at 23:39

The easiest way is to copy another column with the same number of records where each field in that column has no value....then just select, copy, paste...done....

share|improve this answer

Much simpler: right click on the column header in access, select copy. Now go to excel and paste into a excel column. Now hit the delete key, then copy that. Go back to access right click column header and paste. Done.

Note: When selecting what to copy in excel may want to exclude column header or may get extra blank record.

share|improve this answer

Go to the table's Design View and delete the column in question. Then add a new field with the same name as the column you just deleted.

This is the fastest option, particularly if you're dealing with a large table with many millions of rows, because the other listed options will take several minutes while Access is "thinking through" your copy/paste or find/replace criteria. This method is basically instantaneous.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .