Granted, I am new to the world of LogParser but while I at first found it fascinating I am now just frustrated.....! I found some great examples out on the web to collect event logs from servers and put the data into a SQL table. This was working great - for about a week then all of a sudden they stopped...

That´s what I mean. Thanks for your help. I will test it next week.

From your original description, it sounded somewhat like you want to be able to import an event file more than once, but each successive time, importing only the new records. That is what the checkpoint feature does. Read the section of the help file under Log Parser | Advanced Features | Parsing Input...

I know that help file and i have used it, but i didn´t found something that would help me to solve my problem. I must say, that im really not an expert with SQL. So it´s possible that i read it, but didn´t realized that it would solve my problem. Do you know where I can find it in the help file?

When you installed Log Parser, you got a help file (logparser.chm). It is in the same directory as the program (by default, C:\Program Files\Log Parser 2.2). That help file is a complete user manual with plenty of information about all the different input formats and also a great instruction on the...

Sorry, but I don´t know which site you mean. Can you please tell me the way to the site!

Read the help file. I especially suggest the pages dealing with checkpoint files.

Can nobody help me? I want to know, how to add Data in an existing MySQL Database without duplicates?

Daniel thanks for the tip. It works fine now

Your SELECT clause can have static values in it that do not relate to fields in the source file. e.g. if I have a text file with three columns, A B C and I want to save the contents of that file into a table that has A B C D E, I could use the following query: SELECT A, B, C, 'default', NULL INTO tablename...