Do you know ?
I am not sure if you have noticed this with some of Excel older versions for Eg: 2003. When you have a mdb which has more than 65,536 rows lets say 65,537, now when you try to pull in these mdb records into Excel? What happens then. You will notice that there will not be any error message flashed by Excel. So it hard to catch it, but the cause is pretty simple. We are trying pull in more rows than the capacity of Excel which is not possible.
This limitation of Excel 2003 is not present in Excel2007.
Cheers!!
This blog is about Technology. One ultimate destination for tutorials on programming languages, exploring about complex situations in different programming languages. Also Knowing about most wanted technologies now and in Future. The Major content as of now will be focussed on Excel and Visual Basic for Applications(VBA). Have a happy reading...!!
Tuesday, November 24, 2009
Subscribe to:
Post Comments (Atom)
Followers
Blog Archive
About Me
- Ravindra Singh Yadav
- Hello World!. I am an aspiring blogger, striving towards knowing more about various Technologies and innovating about it. I am full of Energy, Enthusiasm to learn more and more....
Added knowledge, thanks
ReplyDeleteits good knowledge bro..
ReplyDeleteI was not aware of this topic.. It's good to learn new topics. I love to learn more new things. thanks for sharing the information with us. Ecommerce web development
ReplyDelete