March 25, 2013 at 1:51 pm
Hi all,
-----------------------------------------------------------------------------------------
Could not retrieve the table information for the connection manager 'Excel Connection Manager'.
Failed to connect to the source using the connection manager 'Excel Connection Manager'
-----------------------------------------------------------------------------------------
I am using VS 2010, MS office 2010 & windows 7 64-bit machine. Though i installed the Access db engine 2010 redistributable_x64, i couldn't find these drivers in the list of providers in oledb source.Also, i tried changing the run 64 bit runtime to false, but still the problem persists. Any help will be appreciated. Thanks in advance.
March 26, 2013 at 4:49 am
This was removed by the editor as SPAM
March 26, 2013 at 8:24 am
vamsinamburu (3/25/2013)
Hi all,-----------------------------------------------------------------------------------------
Could not retrieve the table information for the connection manager 'Excel Connection Manager'.
Failed to connect to the source using the connection manager 'Excel Connection Manager'
-----------------------------------------------------------------------------------------
I am using VS 2010, MS office 2010 & windows 7 64-bit machine. Though i installed the Access db engine 2010 redistributable_x64, i couldn't find these drivers in the list of providers in oledb source.Also, i tried changing the run 64 bit runtime to false, but still the problem persists. Any help will be appreciated. Thanks in advance.
Make sure you have the 32-bit ACE OLE DB drivers installed, as BIDS/SSDT is a 32-bit application.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply