Append excel import to existing SAS output

[sheetalmahana]

Hi, I have an excel file (.xlsx) which are named in ddmmmyy format in a folder. I am able to import the files into SAS. Everyday 1 excel file is added to the folder. I already have the code to import it and get it into SAS. Problem occurs when i import today's file into SAS, previous day's file is getting overridden with today's data. Please suggest a way to overcome this issues and automate the code. 

[LinusH]

Step 1: import to temporary SAS table

Step 2: PROC APPEND to the permanent table