Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ISERROR,SMALL,INDEX, MATCH, SMALL?? | Excel Discussion (Misc queries) | |||
Small Caps in Excel | Excel Discussion (Misc queries) | |||
HOW DO I SET UP A SMALL BUSINESS USING EXCEL? | Excel Discussion (Misc queries) | |||
How can I add a small .gif in an Excel cell? | Excel Discussion (Misc queries) | |||
small excel project | Excel Programming |