Thanks a lot for prompt reply, i am new to vba macros and didnt actually get what you said, i am recording a macro that will first open text file in excel, do text to column function and append the data from this sheet to master excel database, so basically, what my check is if the data already imported formatted from text file it should not append second time.

hope its clear and waiting for a simple solution.