a guest Jun 14th, 2018 62 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- sp_configure 'show advanced options', 1;
- sp_configure 'Ad Hoc Distributed Queries', 1;
- SELECT * INTO Data_dq
- FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0',
- 'Data Source=C:UsersmusayevkDesktopaaa.xlsx;Extended Properties=Excel 12.0')...[Data$];
- Error Log
- Msg 7438, Level 16, State 1, Line 2
- The 32-bit OLE DB provider "Microsoft.ACE.OLEDB.12.0" cannot be loaded in-process on a 64-bit SQL Server.
- "C:Users%User%DownloadsAccessDatabaseEngine_x64.exe" /passive
RAW Paste Data