extracting data from excel

How extract data from Ms-excel ?

using VLOOKUP, INDEX and MATCH, HLOOKUP, etc
if u want to know more visit : http://excelwhiz.wordpress.com/


"Ravindra" wrote:

> How extract data from Ms-excel ?

More information required. Pehaps save as with a different file format
option, perhaps send from the file menue, perhaps something more specific.


"Ravindra" <Ravindra@discussions.microsoft.com> wrote in message
news:178B4727-FE52-4662-8B32-60C8201A412C@microsoft.com...
> How extract data from Ms-excel ?

Ravindra,

Just to add to David's request for clarification...

Do you want to extract data from Excel:

1. To a program? Then you could use Excel's exposed COM interfaces.
2. To a database? If using SQL Server you can build a DTD from using SQL
Server's ETL application (which I don't have installed and I can't remember
what it's called). Otherwise, you can save the xls file some other format
supported by the target database for a load/import.
3. To another workbook? Then you would use code behind, either VBA or
C#/VB.NET (after an install of VSTO) and programmatically extract the data to
your new workbook.
4. I'm sure there are other scenarios.

Excel is a very powerful tool and you have a lot of options as to how to use
it. So what are you trying to do?

Thanks,

Kim Greenlee
--
digipede - Many legs make light work.
Grid computing for the real world.
http://www.digipede.net
http://krgreenlee.blogspot.net