|
I am trying to use OpenRowSet to import XLS file into Database in SQL 2008 and I got the following error - The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered. Here is my queries - I am using 64bit Windows 2003 and SQL Server 64bit version... According from the Microsoft, Jet Driver is only runs on 32 bit version. Is that correct? Thanks.
(comments are locked)
|
|
Just for completeness, please take a look at this previous question about Excel Imports in a 64Bit environment Jet 4.0 was never ported to 64 Bit (it caused a huge outcry but MS never did anything about it!). @Oleg and @Pawel both provide great info into how it can still be done. @William Thanks. Sorted. By the way I don't understand why my screen shorts are disappeared.
Nov 30 '10 at 07:11 AM
Leo
Your answer was turned into a comment and that removed pictures (they are not part of comments). That seems to be a current "feature" of OSQA.
Nov 30 '10 at 07:39 AM
WilliamD
(comments are locked)
|
|
Personally, if this is an infrequent/one-off task I would save the Excel data as a csv file and use LogParser - http://www.simple-talk.com/community/blogs/jonathanallen/archive/category/1043.aspx otherwise you will probably need to set up an SSIS package to do the import with the right Jet drivers. Yes, I did create the SSIS at the end. Thanks.
Nov 30 '10 at 03:54 AM
Leo
(comments are locked)
|


Where is that option to change 64 bit to 32 bit run time in SSIS package?
Also - getting error in SSIS pacakge
95
95
In the first picture you supply there is the debug option "Run64BitRuntime" - set this to false.
Please read through the answers in the link I provided, Oleg and Pawel explain it quite well there.