Hi mate,

I'm not sure exactly about your requirements But you can try this script(nice & easy) if it could help you?????

declare @startRow int ,@Totalpages int,@RowsEffected int,@pagesLeft int ...

guys that's great opportunity. But can somebody post a link to download all of the stuff. Thanks

This is really a great article with great simplicity.

Thanks for sharing.

Please keep it up

Hi Jeff, This is my Code.

insert into OPENROWSET(

'Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\Contact.xls;;HDR=YES','SELECT * FROM [Sheet1$]')

select *...

Hi All,

I tried "Openrowset" but it is not working. The error is "Could not find sheet1$". I am using MS Excel 2003 and SQL Server 2005. Please any one have...