Share via

Import excel data to sql

Nana Kwabena Achampong 0 Reputation points
2023-06-14T22:51:57.6+00:00

TITLE: SQL Server Import and Export Wizard

An error occurred which the SQL Server Integration Services Wizard was not prepared to handle.

ADDITIONAL INFORMATION:

Could not load file or assembly 'Microsoft.DataTransformationServices.ScaleHelper, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (DTSWizard)

BUTTONS:

OK

Kindly help, this keeps coming when I try to import excel data

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,551 Reputation points
    2023-06-15T01:48:32.0433333+00:00

    Hi @Nana Kwabena Achampong，

    Please use select @@version to check your sql server version first.

    If you are using SQL Server 2022, a thread with the same error, where some users fixed the problem by uninstalling and re-installing again but some fixed through adding the SQL Server integration services to your SQL Server installation. Reference: Error with my SQL Server 2022 preview Import and Export Wizard - Microsoft Community Hub.

    If not, please use the SQL Server Import and Export Wizard32bit or 64bit for a try.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.