View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
 
Posts: 593
Default 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.

--