As per my understanding, u have set the flat file connection manager configuration setting correctly. You need to specify the delimiter in the connection manager.
It is possible to insert the values into the same excel sheet without appending. U need to delete the records and then insert the values. Please let me know...