In Microsoft Access how do you delete all values in a single column without deleting the entire field.

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

6 Answers

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

Update [Table Name] Set [Field Name] = null

3

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.

1

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....

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.

1. Select the field in table view

2. Open Find and Replace

   Find What: *

   Look In: Current Field

3. Replace all

That's it.

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.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy