| Author: www.DotNetVJ.com 30 Jun 2008 | Member Level: Diamond | Rating:  Points: 6 |
Hi,
The way i see instead of putting this condition to select 5th or 20th row, blidnly get all the data into staging area in SQL Server and from there use simple stored procedures to apply your filtering logic and move it to target/main tables.
Check out the below link for more information
http://www.builderau.com.au/program/sqlserver/soa/How-to-import-an-Excel-file-into-SQL-Server-2005-using-Integration-Services/0,339028455,339285948,00.htm
Thanks -- Vj
http://dotnetvj.blogspot.com
Thanks -- Vijaya Kadiyala
http://www.DotNetVJ.com
Microsoft MVP
Me & My Little Techie
|
| Author: Sriram 01 Jul 2008 | Member Level: Gold | Rating: Points: 1 |
Excel to Sql server is Possible but we cant able to select
5 Row to 100 Row
SriramRamaswamy
|