I am attempting to load into SQl data from an excel file as this process is tedious and I want to automate this for ease of use.
I am running SQL mgmt studio on my workstation with x64 office 2010 and x64 database engine. SMS is connected toa remote SQL 2008 R2 server ( our DEV server). I continue to recieve the error, do I neet to install Excel on teh server or just simply install the database engine on the server?
My query is as such:
SELECT * INTO Test_Inactivation
'Excel 12.0 Xml;
Database=C:\Users\USER\Desktop\Tabithas - Inactivation routine\Accounts that failed COA Update.xlsx',
--I have registerd the object
EXEC sp_configure 'Show Advanced Options', 1;
EXEC sp_configure 'Ad Hoc Distributed Queries', 1;
Msg 7403, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.