Please Help me - How can I fix the 'Culture is not Supported' error when importing an Excel file to a database in SQL Server Management Studio

Question

I have tried countless times to import an Excel file via the SSMS application interface and keep getting the below error.

Error 0xc002f210: Preparation SQL Task 1: Executing the query "CREATE TABLE [dbo].[CovidDeaths$] (

iso_code] NV . " failed with the following error: "Culture is not supported.

Parameter name: Culture

3072 (0x0c00) is invalid culture identifier.". 

Possible failure reasons: Problems with the query. "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

--

I want to state that I have downloaded the accessdatabaseengine.exe file to prevent the original importation error via the app or even via the SSMS Interface, but I still can't import an Excel file using the SSMS file. I don't know why, and please, I need help fixing this. Meanwhile, I wasn't experiencing this before, but started experiencing it after I reset my system for an important reason, and I have to download every app again, but I don't think that's the problem. Do you?

I have also uninstalled and re-installed both SQL Server and SSMS countless times, but I keep getting an error.

Please help me.

I have looked at the following links below and still can't decipher the exact thing to do to fix the problem:

Link 1: https://support.microsoft.com/en-us/topic/kb4570433-fix-culture-is-not-supported-error-or-wrong-results-occur-when-you-run-polybase-query-in-sql-server-2019-f3f4da4f-6416-ec4c-3c9c-5f81f60dc229#:%7E:text=resolution

Link 2: https://learn.microsoft.com/en-US/troubleshoot/sql/releases/sqlserver-2019/cumulativeupdate6

Link 3: https://learn.microsoft.com/en-US/troubleshoot/sql/releases/sqlserver-2019/build-versions

Answer 1

Unbelievable! It turns out it was my settings in Regions - Format in Windows settings.

Here's what I did:

1. Go to Control Panel
2. Go to Clock and Region
3. Go to Regions and change the settings to English (United States).

Turns out SSMS only recognizes that format and other formats like English (UK) or English (Nigeria), or English (World) were new to it.

Answer 2

I also just noticed that the Excel File gets imported, but the table is empty. I checked the first 1000 rows, and I only see the column headers' names in the output.