Re: $$Excel-Macros$$ How to read a log file using excel VBA code

Thanks for the help...:) On Jul 28, 11:04 am, NOORAIN ANSARI wrote: > Dear Praneet, > > Please convert your Excel File in Access and use below query > > SELECT Logfile.Salary from Logfile > > WHERE (Logfile.Name)=[Enter a Name]; > > *ORDER BY *Logfile* ASC* > > -- > Thanks & regards, > Noorain An

Re: $$Excel-Macros$$ How to read a log file using excel VBA code

I am very sorry I can't provide raw data. As it is company's confidential information. But thanks for your reply. Will try to use MS Access. :) On Jul 27, 10:12 pm, XLS S wrote: > Dear Praneet, > > Use Ms Access,..is it possible  to provide the data? > > please provide the raw data >

Re: $$Excel-Macros$$ How to read a log file using excel VBA code

Dear Praneet, Try Ms Access(or)Sql Server.. -- *Best Regards,* *Venkat* *Chennai* * * On Wed, Jul 27, 2011 at 10:42 PM, XLS S wrote: > Dear Praneet, > > Use Ms Access,..is it possible to provide the data? > > please provide the raw data > > > > > On Wed, Jul 27, 2011 at 10:33 PM,

Re: $$Excel-Macros$$ How to read a log file using excel VBA code

Dear Praneet, Please convert your Excel File in Access and use below query SELECT Logfile.Salary from Logfile WHERE (Logfile.Name)=[Enter a Name]; *ORDER BY *Logfile* ASC* -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Wed

Re: $$Excel-Macros$$ How to read a log file using excel VBA code

Dear Praneet, Use Ms Access,..is it possible to provide the data? please provide the raw data On Wed, Jul 27, 2011 at 10:33 PM, Praneeth Akinapalli wrote: > Hi Experts, > > I have a .log file (TXT doc) with 80,000 rows. I only need 20 rows of > data based on a single column fro

$$Excel-Macros$$ How to read a log file using excel VBA code

Hi Experts, I have a .log file (TXT doc) with 80,000 rows. I only need 20 rows of data based on a single column from that log file. I am currently using 2003 excel. Can anyone please give me logic on how to read that particular data from log file. Actually I tried importing the log file and then