You can certainly use excel as a database, and read/write/update etc using
ADO, but this requires a fair bit of automation. I think you can access SQL
databases, but I haven't got that far yet. Go to the VBE Editor, then the
VBA Help and search on ADO. Office 200 onwards I believe
Joe
"Rachel" wrote in message
om...
Hello all,
I need to use Excel as my database because my company needs to save
the data in flat files.
Can I define tables in Excel?
Can I retrieve/update records matching set criteria from several
tables?
Can I use SQL?
Thanks a lot,
Rachel
----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---