Hi,

I have following excel sheet because for formatting I'm not able to get values of '
$ 50,265,539.06

and date '8/5/2011'

I did like take a excel source and in openrowset property i set 'SHEET1$B11:C3'

values because price is at b11 and date is at c3

So please let me know how can i get these two values and insert into table ??

http://social.microsoft.com/Forums/getfile/13647/