What do you mean with dissapears?
What is the expression?
Regarding the need for an Excel file to be present: unlike a flat file, you need to look at an Excel workbook as a database. The workbook is the database, the sheets are the tables. When you write data to a database, you'd expect the database and the tables to be there, don't you?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP