import from excel, ACE and 64-bit

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

import from excel, ACE and 64-bit

Author

Topic

lucifer
Starting Member

3 Posts

Posted - 2012-10-25 : 17:27:43

Hi.

Just installed mssql 2008 rs and I want to import from excel. In the beginning I ran the 32-bit where ofcourse it thrown exception that Microsoft.ACEetc.. are not registered.

The 64-bit on the other hand do not have the Excel option.

Is there anything I can do?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-10-25 : 17:28:38

you need to install excel provider for 64 bit

see

http://blog.oraylis.de/2011/05/ssis-goodie-1-excel-ssis-64-bit-dts_e_oledb_excel_not_supported/

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/