Hrm. Well I was able to get LP to create an Excel spreadsheet via ODBC, but the driver throws an "Optional feature not implemented" error that I don't have enough time to figure out. If you are more familiar with the ODBC Excel Driver or have more research time, you might be able to get further. lp ...

I have tried both of these options attempting to parse a subset of data from a persisted XML file into an Excel Sheet. I take it neither are supported as SQL Output with LogParser. Stan

Dear all, hoping to get some help as i'm new to logparser. I have searched the Toolkit book and googel'd quite a while now - but without success ..... here's my problem : Input File is XML wich looks like this some.computer.net C:\ incr 123456789 10 12.12.2006 i put this values into a SQL Tabele wich...

Still, make sure you are running 2.2.10 not 2.2.9. I suspect you might be running something other than .10 because the syntax change from: SELECT ... FROM ... TO ... to: SELECT ... INTO ... FROM ...

Got it. Just TO_INT(FIELDx).... Thanks.

I'm using logparser 2.2. Any new version? Varchar column has no problem but int.

Try upgrading to the latest version?

Hi, dear I'm tring to import some IAS logs (CSV format) into SQL Server. When I use "select .... from file to table ....", the CSV may return some column with no data. It should be displayed as "<NULL>". But the SQL did not treat <NULL> as NULL. It report that type is not compatible. So I...

[QUOTE User="LogParser User : sotherls"]Quote: I think your version of LP might have been downgraded. The version should be 2.2.10.[/QUOTE] You my friend are a GENIUS! That was the problem!!!! Thank you!

I think your version of LP might have been downgraded. The version should be 2.2.10.