News for hackers. Stuff that matters.

A comment on Stop Using Excel, Finance Chiefs Tell Staffs. Parent comment

Re:Stop Using Excel, Finance Chiefs Tell Staffs by fjsolwmv on Wednesday November 22, 2017 @11:19AM (#15757967)
Does access have a spreadsheet view for bulk editing?
[ Parent | on HN ]
Re:Stop Using Excel, Finance Chiefs Tell Staffs by tinus_hn on Wednesday November 22, 2017 @11:56AM (#15758296)
Yes, it’s called the datasheet view.
[ Parent | on HN ]
Re:Stop Using Excel, Finance Chiefs Tell Staffs by TakerofVita on Wednesday November 22, 2017 @05:24PM (#15761209)
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.
[ Parent | on HN ]
Re:Stop Using Excel, Finance Chiefs Tell Staffs by phkahler on Wednesday November 22, 2017 @06:44PM (#15761694)
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.
[ Parent | on HN ]