sql server - How to Bulk Insert from XLSX file extension?

Question

Can anyone advise how to bulk insert from .xlsx file?

I tried the below query already:

BULK INSERT #EVB FROM 'C:UserssummerDesktopSamplepremise.xlsx' 
WITH (FIELDTERMINATOR = '', ROWTERMINATOR = '
', FIRSTROW = 2);

SELECT * FROM #EVB

I also tried with FIELDTERMINATOR like "****", "**,**", "**;**", "**|**", but this doesn't work either.

Unfortunately, there is no error message.

Answer 1

you can save the xlsx file as a tab-delimited text file and do

BULK INSERT TableName
        FROM 'C:SomeDirectorymy table.txt'
            WITH
    (
                FIELDTERMINATOR = '',
                ROWTERMINATOR = '
'
    )
GO