Hot answers tagged

5

My question is ... how I can map db tables in excel files to give it to users instantly, when they want to download a table? Simple answer: you can't, unless you have the files prepared in advance. .xlsx files are ZIP archives which can't easily be produced in a streaming fashion, so to give one to the user you will need to create it from the database ...


4

I've shied away from Access because my team is not comfortable using SQL and overall dislike the Access Interface. Here's your answer. There is a strong argument to use Excel because it is what your team is comfortable with, and that is pretty darned valuable. But managing multiple workbooks (with changing names) has already created several version ...


4

I would question the very premise of the question that Excel/VBA is "unsafe", that it is a "home" application, or that it is hard to maintain when applied to appropriate problems. Excel and VBA is widely used by professionals in the largest corporations, and (due to the ubiquity of Excel and its built-in VBA editor) it is amongst some of ...


4

You tackle this problem like you would tackle any other software engineering problem: by gathering requirements, designing the software, writing it, testing it, and so forth. Having spreadsheets that already do this just means that some of the requirements gathering has already been done for you. The manner in which you organize the software is where the ...


3

You can install BERT as an add-in in Excel. Then in Excel you can enter the R console for basic coding and debugging. And for the clients, you wrap your R function into a new file saved to the startup folder, so BERT can load all the functions from there, and clients can choose whatever they want in Excel directly. customized_function <- function(data){ ...


2

The datamodel is (mostly) independent of the database. Excel is not a database. Ms Access is a great RAD (rapid app devel) frontend, but db (MDAC/Jet) is limited on multiuser, security and backup (no dumps, binary log, etc), but fast and no db-server needed! You can work with Excel, but fetch data from a db (company enviroment Sql Server, MySql, Postgre ...


1

For each distinct source, write some code which normalizes data from this source. Insert the normalized data into the database. Realize that this doesn't scale, and request that the sources provide data in a common format so you don't have to write a normalizer for each one. Realize that your sources are not under your control and won't adapt to your needs. ...


Only top voted, non community-wiki answers of a minimum length are eligible