Thread
:
SQL in Excel?
View Single Post
#
3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Tushar Mehta[_6_]
external usenet poster
Posts: 19
SQL in Excel?
For a non-programmatic solution, check the 'RDBMS in Excel' tutorial on
my web site.
--
Regards,
Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
In Excel 2000/XP is it possible to treat a range of cells as a table and run
sql statements against it? for example in sheet1 I have 3 columns Item_code,
quantity, amount. If I want to calculate the total quantity, and amount for
every Item to appear in Sheet2 which I could get by the following SQL
statement
select item_code, sum(quantity),sum(amount)
from table_name (or range of cells)
group by item_code
thx
Reply With Quote
Tushar Mehta[_6_]
View Public Profile
Find all posts by Tushar Mehta[_6_]