Re: $$Excel-Macros$$ Re: Query to retreive data

2015-04-28 Thread Vaibhav Joshi
you dont need access, you can continue using excel & thru DAO you can retrieve data from closed workbook too.. On Wed, Apr 29, 2015 at 10:35 AM, Nasir Saikh wrote: > r8 Pramod access is very easy and taking very less time than excel on huge > data you can use it till 2 GB data. > > On Tuesday, A

Re: $$Excel-Macros$$ Re: Query to retreive data

2015-04-28 Thread Paul Schreiner
I'm curious about your file size and response issue. What version of Excel are you using?As ask because I use Excel 2010 and have a file that is generated from 5 different data sources.The file contains 29 sheets,one of which contains 145,500 rows and 74 columns.There are 27 macro modules contai

Re: $$Excel-Macros$$ Re: Query to retreive data

2015-04-28 Thread Pramod Singh
Why not you are using MS Access. It's pretty cool and can we use easy.. this is best for if some one have to work in large data Pramod On 28 Apr 2015 15:41, "Mandeep Baluja" wrote: > Yes it works, Thanks for the same we can considered this issue is > resolved. But one thing Excel is not usef