up vote 1 down vote favorite
share [g+] share [fb]


I have big file that contains log information. Suppose, it in CSV format and has table structure. I want tool that can load this file and make some queries. For example: show often repeated entries, count of same entries etc.

link|improve this question
feedback

4 Answers

up vote 1 down vote

'excel' comes to mind. otherwise 'r', the language for statistical computing, especially 'importing spreadsheet like data' is worth reading.

link|improve this answer
file contains thousands of records so excel doesn't match and visual tool will preferred. – user23099 Dec 30 '09 at 14:38
excel is capable of displaying 32k rows ... – akira Dec 30 '09 at 16:01
feedback
up vote 1 down vote

Microsoft Access

link|improve this answer
Didn't find how to import data – user23099 Dec 30 '09 at 14:40
1  
Look harder. :) Try opening the csv file with Access. – phoebus Dec 30 '09 at 14:58
feedback
up vote 1 down vote

Try Microsoft's Log Parser. Some more info here, and a GUI for it here.

link|improve this answer
feedback
up vote 0 down vote

Excel is your best bet. I agree with @akira

Access is too complicated for this task. You would have to mess around with wizards and not quite get what you want or figure out SQL

Excel is more than enough 'visual'. You can make pivots and charts to get a better sense of your data

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard