question

PamelaWhittaker-2747 avatar image
0 Votes"
PamelaWhittaker-2747 asked ·

sql server management Studio

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

sql-server-general
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GuoxiongYuan-7218 avatar image
1 Vote"
GuoxiongYuan-7218 answered ·
·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered ·

Hi @PamelaWhittaker-2747,

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



01.jpg (49.1 KiB)
·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.