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]http://ask.sqlservercentral.com/questions/28523/importing-excel-data-into-sql-server-table?page=1#28524
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.: http://www.simple-talk.com/community/blogs/jonathanallen/archive/category/1043.aspx
answered Nov 30 '10 at 03:47 AM