Guest User

Untitled

a guest
Jun 14th, 2018
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. sp_configure 'show advanced options', 1;
  2. RECONFIGURE;
  3. GO
  4. sp_configure 'Ad Hoc Distributed Queries', 1;
  5. RECONFIGURE;
  6. GO
  7.  
  8. SELECT * INTO Data_dq
  9. FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0',
  10. 'Data Source=C:UsersmusayevkDesktopaaa.xlsx;Extended Properties=Excel 12.0')...[Data$];
  11.  
  12. Error Log
  13. Msg 7438, Level 16, State 1, Line 2
  14. The 32-bit OLE DB provider "Microsoft.ACE.OLEDB.12.0" cannot be loaded in-process on a 64-bit SQL Server.
  15.  
  16. "C:Users%User%DownloadsAccessDatabaseEngine_x64.exe" /passive
Add Comment
Please, Sign In to add comment