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

2011-07-29 Thread Praneeth Akinapalli
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 xlst...@gmail.com wrote: Dear Praneet, Use Ms Access,..is it possible  to provide the data? please provide

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

2011-07-29 Thread Praneeth Akinapalli
Thanks for the help...:) On Jul 28, 11:04 am, NOORAIN ANSARI noorain.ans...@gmail.com 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,

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

2011-07-28 Thread NOORAIN ANSARI
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/* http://noorain-ansari.blogspot.com/ On Wed,

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

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

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

2011-07-27 Thread Praneeth Akinapalli
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

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

2011-07-27 Thread XLS S
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 praneeth...@gmail.com wrote: Hi Experts, I have a .log file (TXT doc) with 80,000 rows. I only need 20 rows of data based on