14,494 questions
What exactly do you mean with "detect" here?
That's really to less on information, please provide more details like tool you are using and how you try to import the Excel file.
Excel file not detected when importing file in SSMS 2019
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 60%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEZ%3C/text%3E%3C/svg%3E)
Eli Zulkatri
1
Reputation point
When I tried to import data xlsx to SQL, the file is not detected in my computer. Please help to those can help. Thank you
SQL Server Other
{count} votes
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff2022-09-28T07:39:10.057+00:00 Hi @Eli Zulkatri ,
Any progress of your issue? Did the reply could help you? If the response helped, do "Accept Answer". If it is not work, please let us know the progress. Then we can give you a continued help.
Sign in to comment
3 answers
Sort by: Most helpful
-
Olaf Helper 47,436 Reputation points2022-09-23T06:21:07.997+00:00 -
Eli Zulkatri 1 Reputation point
2022-09-23T06:30:58.37+00:00 I use Microsoft SQL Server Management Studio (Administrator). I create new data base, and then I I want to import excel file to my database SQL. Step: Task>Import Data>Data Source: Microsoft Excel>Browse> "excel file are not showing in my PC when I clicked browser ". So I can't select any excel file.
Sign in to comment -
-
Olaf Helper 47,436 Reputation points
2022-09-23T06:50:36.973+00:00 My guesses:
- There is no Excel file in the folder
- You work with SSMS as remote app (Terminal Server, Citrix). In this case the Imp/Exp wizard shows the files from the server, not of your client machine
-
Eli Zulkatri 1 Reputation point
2022-09-23T07:04:44.103+00:00 - There are few of excel file in my pc and also in the folder, but all of the are not showing. I do not know why.
- No idea about my SSMS remote app or not. Bu do you have any suggestion for me regarding this issues?
Sign in to comment -
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
2022-09-26T03:25:40.21+00:00 Hi @Eli Zulkatri ,
According to your description, please check below.
- Please make sure that the excel file is existed on your PC, and your admin account has read and write permission on this Excel file. You can check this on security option of file (folder) properties.
- Please make sure that you choose the right version for your Excel file in below step.
> No idea about my SSMS remote app or not. Bu do you have any suggestion for me regarding these issues?
For example, if you using SSMS on server A to connect to SQL server on server B, this is a remote connection. In this situation, it only shows the Excel files on server A not server B.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".