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/

Go to Top of Page

lucifer
Starting Member

3 Posts

Posted - 2012-10-25 : 17:33:18
great, thanks!
Go to Top of Page

gogogoa
Starting Member

1 Post

Posted - 2012-11-06 : 15:01:22
try [url]http://excel2sql.vlez.be/[/url]
Go to Top of Page
   

- Advertisement -