Use SQL Server to import and export wizard import Excel file to the database when a path and file name why many out under the table?

Show hidden project was installed on my computer, so not the hidden below;
Excel to restore the contents of the file location is empty, so that is not to restore files;

Problem after: when open the SQL Server import and export wizard again open the Excel file, probably because of a file by two procedures for conflict where this situation will keep wrong file? I use Office is 2016, now open the Excel file didn't see the temporary file, and then appear below the table, more import for the first time, but failed to import for the first time, the import failure under the path of the file will appear in where?

CodePudding user response:

I often encountered this kind of situation, what I said is not good, but the general content is same with experience, is not the same general first is right,
You point to hook preview

CodePudding user response:

Do you have 2 SHEET that EXCEL file?