SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 import from excel, ACE and 64-bit
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

lucifer
Starting Member

3 Posts

Posted - 10/25/2012 :  17:27:43  Show Profile  Reply with Quote
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

India
52249 Posts

Posted - 10/25/2012 :  17:28:38  Show Profile  Reply with Quote
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/


Edited by - visakh16 on 10/25/2012 17:29:30
Go to Top of Page

lucifer
Starting Member

3 Posts

Posted - 10/25/2012 :  17:33:18  Show Profile  Reply with Quote
great, thanks!
Go to Top of Page

gogogoa
Starting Member

1 Posts

Posted - 11/06/2012 :  15:01:22  Show Profile  Reply with Quote
try http://excel2sql.vlez.be/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000