![]() Microsoft Access Database Engine 2010 Redistributable on both local server. 60 64 bit is running on an other Microsoft Server 2012. PRINT('FOUND : ' + OPENROWSET processing goes here, using to identify which file to useĭelete from #files Where excelFileName = have reinstalled office to office 2016 64 bit(dubble checked). ![]() SET = 'select * into #MyAppORsuiteInt FROM OPENROWSET(''.4.0'', ''Excel 8.0 Database=' + + ' HDR=YES'', ''SELECT * FROM '') ' Select Top 1 = excelFileName From LIKE '%.csv' OR LIKE '%.xlsx') ![]() While (Select Count(*) From #files where excelFileName is not null) > 0 ![]() ![]() RECONFIGURE - To update the currently configured value for advanced options.ĮXEC sp_configure 'xp_cmdshell', 1 - To enable cmdĮXEC sp_configure 'Ad Hoc Distributed Queries', 1 -To enable to execute OPENROWSET.ĮXEC sp_MSSet_oledb_prop N'.12.0', N'AllowInProcess', 1ĮXEC sp_MSSet_oledb_prop N'.12.0', N'DynamicParameters', 1ĮXEC _MSset_oledb_prop N'.4.0', N'AllowInProcess', 1ĮXEC _MSset_oledb_prop N'.4.0', N'DynamicParameters', 1ĬREATE TABLE #files(excelFileName VARCHAR(100)) In Microsoft SQL Manager 2014(on Windows 10) when running this StoredProcedure : -Allow for SQL to use cmd shellĮXEC sp_configure 'show advanced options', 1 - To allow advanced options to be changed. The 32-bit OLE DB provider ".4.0" cannot be loaded in-process on a 64-bit SQL Server ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |