Hi Rick,
I've done some small DB in Excel just as Tom Ogilvy mentioned. Kee
tables in different worksheet and you can even use Microsoft's Query3
to analyse those data in Excel's via ODBC connection. Just select Exce
file* when choosing Data Source when asked. Remember to tick all fou
tick boxs in Add Table's Option in MS Query32. Then you can see table
end with a $ in names. They are actually worksheet names. You can us
SQL in those table in Excel just as you do in other DB's. Using SQL ca
give you better means to analysis data than just using those built-i
command in Excel's Data menu.(eg. selecting data by meeting more than
criteria).
Huyeot
--
Huyeot
-----------------------------------------------------------------------
Huyeote's Profile:
http://www.excelforum.com/member.php...fo&userid=1389
View this thread:
http://www.excelforum.com/showthread.php?threadid=26882