How do you drag-and-drop data down a column in an access table?

[Guest]

How do you drag-and-drop data down a column in an access table? I want to be
able to do this in Access just like you can in Excel, is this possible?
Thank you for your help as it will save me a TON of time!

 

[Douglas J. Steele]

While the datasheet view in Access may look like an Excel spreadsheet, you
need to realize that they are very different tools. The idea of
dragging-and-dropping a column worth of data is foreign to relational
databases: if the field should have the same value for every row in the
table, odds are it shouldn't be in that table, but in a separate related
table instead.

If you do have a legitimate need to update a particular field to the same
value for each row, an Update query is the appropriate way to accomplish it.