![]() If you have anyĬompliments or complaints to MSDN Support, feel free to contact Yang, thanks for your reply. This can be beneficial to other community members reading this thread. MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. It looks like you didn't install 32-bit ACE Driver. ![]() 1x.0 is not registered.Īny suggests to me to solve this issue? Thanks If I open the advanced editor for the Excel source I can see an error message about I've tried to three different Excel versions for the Excel connection manager, 2007-2010, 20, but without any results. I've created an Excel connection manager, but when I use it for an Excel source I cannot read data. I've created a SSIS 2017 solution and for the project I've Run64BitRuntime option to True. I've created a sample Excel 2016 file to try to read from it. Moreover, I've installed Microsoft Access Database Engine 2016 Redistributable components. On my machine I've SQL Server 2017 64-bit and SSIS 2017, SSDT for Visual Studio 2017, Excel 2016 64-bit (Office Professional Plus). ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |