How can I import the contents of an Excel file into an existing Table please? Thanks
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.
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.
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
10 people are following this question.