Re:Excel as a database
by RossP on Tuesday April 09, 2013 @06:47PM
(#5521956)
Yep, it's got it's limits - I would only use this in production with carefully crafted queries to try too counter this problem.
My usual use is against MS CRM data, which puts a 10k line limit on by default. First instinct for many people is to disable the limit, but in reality it's a good fail safe!
My usual use is against MS CRM data, which puts a 10k line limit on by default. First instinct for many people is to disable the limit, but in reality it's a good fail safe!