Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Small DB in Excel


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ISERROR,SMALL,INDEX, MATCH, SMALL?? M.A.Tyler Excel Discussion (Misc queries) 1 May 2nd 07 04:08 AM
Small Caps in Excel Carlo Excel Discussion (Misc queries) 2 September 1st 06 06:45 AM
HOW DO I SET UP A SMALL BUSINESS USING EXCEL? RAH Excel Discussion (Misc queries) 2 August 10th 06 12:49 AM
How can I add a small .gif in an Excel cell? ~JOSh-X Excel Discussion (Misc queries) 4 December 19th 05 02:32 PM
small excel project leonard Excel Programming 5 January 23rd 04 08:29 AM


All times are GMT +1. The time now is 04:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"