Errors in Imprting Excel file to my SQL Tables

Olagunju Oladayo 66 Reputation points
2022-01-28T10:31:31.06+00:00

Hello,

Please, I need your assistance on this.

I have attached the screenshot of the error t0 this message

Thank you169408-screenshot-20220128112232.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,737 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,245 questions
Accepted answer
  1. Erland Sommarskog 101K Reputation points MVP
    2022-01-28T22:50:30.173+00:00

    This error is due to your Regional Settings. I recall that I ran into this error because my Regional Settings were set to English (Sweden), because Windows seemed to recommend that. Once I changed the settings to Swedish (Sweden), everything changed as it should.

    If I remember correctly from a previous post of yours, I would guess that your regional setting is English (Nigeria), which certainly makes a lot more sense than English (Sweden). So if you change it to English (United Kingdom), things should work better. (I would guess that gives more or less the same experience.)

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olagunju Oladayo 66 Reputation points
    2022-01-28T11:12:35.967+00:00

    @Viorel , Alright.

    Thank you

    I have attached the screenshot of the additional details
    would appreciate you if in simple terms tell me what's wrong

    169335-screenshot-20220128120742.png

    0 comments