Trouble importing data using SQL Server Import and Export Wizard

Question

I tried the SQL Server Import and Export Wizard and have the following issues:

1. Importing using Excel File

When I imported using Excel File, this following message displayed. I already installed the OLE DB but it still did not work

2. Import using Flat File Source, I chose the OLE DB Driver for SQL Server as the Destination. I test the connection and it was successful. The data was executed successfully as this picture but it did not appear in my database.

I currently installed all these programs in my computer but it still did not work.

Can somebody help me?

Answer 1

Hi @Huyen Bui,

Seems like 32bit vs 64bit issue.

You may try to install both 32bit and 64bit driver.

https://datasavvy.me/2017/07/20/installing-the-microsoft-ace-oledb-12-0-provider-for-both-64-bit-and-32-bit-processing/

https://www.microsoft.com/en-us/download/details.aspx?id=54920

Regards，

Zoe Hui

---

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

Answer 2

Hi Huyen,

you can try again after installing the Microsoft Access Database Engine.
https://www.microsoft.com/en-us/download/details.aspx?id=54920

after installing, go to installation folder, open a command prompt here and then run

accessdatabaseengine.exe /quiet