View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Joe90[_2_] Joe90[_2_] is offline
external usenet poster
 
Posts: 3
Default Using Excel as my database

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 =---