Share via

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 | Other
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Guoxiong 8,216 Reputation points
    2021-03-12T19:01:59.11+00:00
    1 person found this answer helpful.
    0 comments
  2. AmeliaGu-MSFT 14,011 Reputation points Microsoft External Staff
    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

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.