LogParser Error: Syntax Error: extra token(s) after query: 'Files\Apache'

Question

I am trying to run LogParser to dump all contents from access.log into an equivalent CSV file:

C:\Program Files\Log Parser 2.2>LogParser "select * into foo.csv from C:\Program  Files\Apache Software Foundation\Apache2.2\logs\access.log" -i:ncsa -o:csv

However, I keep getting this error: Error: Syntax Error: extra token(s) after query: 'Files\Apache' and I am unsure of whether I am missing more syntax or I have some format wrong.

Answer 1

Add single quotes around the source log file (if the path has any empty spaces in it).

LogParser "select * into foo.csv from 'C:\Program Files\Apache Software Foundation\Apache2.2\logs\access.log'" -i:ncsa -o:csv