Question : THIS IS A THEORETICAL QUESTION. I am posting it on this site because of this and because I […]
Tag: excel
Set up a SQL Server database based on an Excel file which refreshes automatically
Question : Can I set up a Server database based on an Excel file, which refreshes automatically with any changes […]
SELECT permission denied trying to import data into Excel
Question : We recently migrated to a newer version of a program and migrated its database from SQL Server 2000 […]
How to transfer Right-to-Left text from Excel to SQL Server?
Question : I have a collection of data in my Excel which the language is right-to-Left. My data collection is […]
comparing two values in same column with another column using AND condition
Question : Column A is MOBILE NO. Column B is Agent Id calc MOBILE NO Agent Id 7024226667 A1EXF8ZF unique […]
Excel Query Using MariaDB ODBC Driver
Question : I’m using MariaDB ODBC driver version 3.0.2 for Windows(on Windows 10) and can’t get excel (Excel 2013) to […]
Compare each column in a row and return an error if any of them is different
Question : I’m attempting to find any identifiers with any values that are different in the same row. +————+——–+——–+——–+——–+ | […]
SQL Server 2012 error when exporting to Excel
Question : Let me start off by saying I know little and less about SQL. I received a .bak file […]
Tools for SQL Deadlock Statistics [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
AD group cannot connect to SQL from excel
Question : We have a data warehouse and users are trying to browse the database directly from excel. We put […]