MC vs EXCEL

[Pierre Sahores]

Le jeu 18/09/2003 à 23:02, jbv a écrit :
> Hi again,
> 
> Is there a specialist of Excel on this list ?
> 
> In a project for 1 of my clients, I have a flat database
> on a server whose content is set via a sophisticated
> HTML form and a couple of MC cgi scripts.
> This flat database is a tab-return file with 100 rows
> and 100 cols.
> My client wants to visualize / modify all the content
> at once like in a spreadsheet on his PC, and save
> modifications on the server.
> Further data processing will need to be done on the PC
> (not saved on the server), like generating PDF files
> from sections of the database content, etc.
> 
> Is there a way to do that with Excel (view / modify /
> save the database) or do I have to simulate a spreadsheet
> with MC ?
> 
> Thanks,
> JB

Hi JB

This could probably work :

Replace your flat-file database back-end by an SQL one (Access,
FileMaker, Valentina, MySQL, PostGreSQL,...) you can access trough an
ODBC driver in using the RevDB library on the Revolution CGI side and
Excel on the client-side (the recent issues of MS Excel are able to read
and write via ODBC).

Hope this help.

Bests,
> _______________________________________________
> metacard mailing list
> metacard at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/metacard
-- 
Bien cordialement, Pierre Sahores

Inspection académique de Seine-Saint-Denis
Applications et SGBD ACID SQL (WEB et PGI)
Penser et produire "delta de rentabilité"