LL – Laxmi Lal Menaria Blog!

Tag: Excel

  • Microsoft Excel: The File couldn’t open in Protected View – Security Error Message

    When we receive the error message “The file could not open in Protected View” in Microsoft Excel, it means that Excel application has detected potential security risks in the file. This Protected View is a security feature in the latest version of Microsoft Excel that helps prevent malicious content from running on your computer. This…

  • Import CSV using “Microsoft Access Database Engine 2010” to SQL Server

    [SQL] sp_configure ‘Ad Hoc Distributed Queries’, 1 reconfigure with override SET NOCOUNT ON EXEC master..xp_cmdshell ‘del C:\Temp\Schema.ini’ EXEC master..xp_cmdshell ‘echo [Test.txt] > C:\Temp\Schema.ini’ EXEC master..xp_cmdshell ‘echo ColNameHeader=True >> C:\Temp\Schema.ini’ EXEC master..xp_cmdshell ‘echo Format=Delimited(^|) >> C:\Temp\Schema.ini’ EXEC master..xp_cmdshell ‘echo MaxScanRows=50 >> C:\Temp\Schema.ini’ EXEC master..xp_cmdshell ‘echo CharacterSet=OEM >> C:\Temp\Schema.ini’ EXEC master..xp_cmdshell ‘echo Col1=ID TEXT >> C:\Temp\Schema.ini’ EXEC…