3 ms·

Does access have a spreadsheet view for bulk editing?

• tinus_hn 9y ago
  Yes, it’s called the datasheet view.
  • TakerofVita 9y ago
    Access does have a datasheet view, but it is _much_ less powerful than Excel e.g. copy/paste multiple cells, fill down, and it is SLOWER.
    • phkahler 9y ago
      In a database you don't "fill down". You build a query to generate what you want (enter the expressions once) and click on the "data sheet" view for the query. It's different, but the simplicity of referencing $A$5 in excel and using whatever cells you want as inputs is way simpler than any way you might take user inputs in Access.