Using Excel as my database
"Joe90" wrote ...
You can certainly use excel as a database, and read/write/update etc using
ADO
You can't DELETE using SQL (you can SELECT..INTO a new table and DROP
TABLE on the original but this has limits <g). There are other
missing features e.g. constraints, indexes, reliable data typing,
declarative referential integrity, user accounts for security, etc.
Jamie.
--
|