I'm trying to import a 190 meg .XLSX file to a SQL 2008 (not R2) server. First, I installed "Office 12.0 Access Database Engine OLD DB Provider". But I get the error:
"Operation Could Not Be Completed. No Error message available. Result code db_sec_E_auth_failed"
I found a suggestion to go to the properties tab and insert the path & file name, which now give me the error:
DB_E_ERRORSOCCURRED(0x80040E21). System Data.
Any thoughts ? I have a 2005 server available, but assumed the 2008 (not R2) server would be better to try.