sql server management Studio

Pamela Whittaker 1 Reputation point
2021-03-12T17:15:28.62+00:00

How can I import the contents of an Excel file into an existing Table please? Thanks

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,776 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Guoxiong 8,126 Reputation points
    2021-03-12T19:01:59.11+00:00
    1 person found this answer helpful.
    0 comments
  2. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-03-15T02:43:04.5+00:00

    Hi @Pamela Whittaker ,

    Are there any updates on this issue?
    In addition, if you are using Office 64-bit and importing data using SQL Server Import and Export Wizard, then you need to launch the 64-bit version of the SQL Server Import and Export Wizard via the Start menu-> expand Microsoft SQL Server 20xx folder.

    77559-01.jpg

    Or you can install the Microsoft.ACE.OLEDB 2016 Redistributable 32-bit version and import data from SSMS.
    Please refer to this article which might help.

    Best Regards,
    Amelia

    If the answer is helpful, please click "Accept Answer" and upvote it.
    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

    0 comments