Our organisation tends to spool output from our various databases into various CSV files. These can then be imported into Excel, formatted
accordingly, and e-mailed as attachments to anyone who claims an
interest.
As to how useful or efficient this process is, is something only you'll
be able to answer :-)
Re: Need advice.. ... various CSV files.... These can then be imported into Excel, formatted accordingly, and e-mailed as attachments to anyone who claims an interest. ... Daniel A. Morgan... (comp.databases.oracle.tools)
Re: why>? ...properly conceived spreadsheet models... I can do excel macros; i've written hundreds and thousands of pages ... Anyway, I don't produce reports, regularly scheduled or otherwise. ...Databases aren't unnecessarily 'complex'. ... (microsoft.public.excel)
Re: why>? ... of these companies has over 100 databases.... they're sure as hell not written in Excel; I can't say this in plain ...SOFTWARE DEVELOPMENT OFF OF YOUR UNQUALIFIED WORKERS. ... I ARGUE THAT EXCEL-- ANYONE WHO USES EXCEL TO BUILD REPORTS;... (microsoft.public.excel)
Re: WHY ... After that I run the data into Excel using ODBC to form an intuitive pivot ... > anything about databases.... >>>If you mean reports, then I don't disagree that databases could be more ... >> That sort of thing is built into modern spreadsheets but not databases. ... (microsoft.public.excel)
Re: why>? ...databases,... dont you realize that Access can utilize Excel data... That's not what properly conceived spreadsheet models do ... (microsoft.public.excel)
