Welcome to Microsoft T-SQL Q&A Forum!
You could try this code to test ：
CREATE PROCEDURE [importFile] (@filePath VARCHAR(MAX))
CREATE TABLE #Temp
DECLARE @SQL NVARCHAR(MAX) = ''
SET @SQL = N'
BULK INSERT #Temp
FROM ''' + @filePath + '''
FIELDTERMINATOR = '','',
ROWTERMINATOR = ''\n''
EXEC sp_executesql @SQL
-- to run it:
EXEC importFile 'C:\data care\test\frt.xls'
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.