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?
Just for completeness, please take a look at this previous question about Excel Imports in a 64Bit environment
answered Nov 30 '10 at 04:10 AM
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.
answered Nov 30 '10 at 03:47 AM