Questions tagged [excel]
Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and macOS. Most Excel questions are off-topic here but can be asked on Super User; notable exceptions are questions about Excel files connecting to other databases.
168 questions
0
votes
0
answers
46
views
Is there any way to hide tables when using a ODBC connection in Excel?
When using the ODBC data source, or the Microsoft Query Wizard to connect to a PostgreSQL database, I can see all tables; even though I only have permission to see several. The wizard even shows me ...
- 101
0
votes
0
answers
31
views
Migrate thousand of data from excel into DB
I have rental data from year 2019-2024 in an excel
In that excel, the data consists of tenant name, monthly payment details from jan - dec each year
I have done massaging the data
I need to mapping ...
0
votes
1
answer
2k
views
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"
I have the task of migrating our databases from a Windows 2012 R2 server with SQL Server 11.0.7507 (2012) to a Windows 2019 server with SQL Server 16.0.1110.1 (2022).
I am having issues with opening ...
- 1
1
vote
0
answers
38
views
Power Pivot/Data model issue
Good day,
I am facing two blocking points where I would need your insights please.
I have downloaded all my sheets in power query and made the necessary transformations, including creating a common ...
0
votes
0
answers
429
views
Validate Excel File data source in SSIS package
I need to load a number of Excel files using SSIS package into a SQL Server table. I am able to successfully loop through and load my Excel files into my table I do not have any issue doing that, BUT ...
2
votes
1
answer
3k
views
How to Downgrade MySQL from 8.0.33 to 8.0.28
I need to downgrade because I cannot use MySQL for Excel add-in. How can I do it? I use windows 8.
There is no information on the MySQL's website.
0
votes
0
answers
344
views
How edit .sql file in windows (excel)
I'm not very expert in SQL, i just want edit some tables on my website's phpmyadmin and it takes a lot of time.so I want to export the sql file and edit it on Microsoft excel or any similar tools, but ...
- 1
0
votes
1
answer
233
views
SQL Server export data from synonyms table to excel
I tried to export synonyms table from my server database to excel using SMSS, I choose database, then I choose export, and manage source and dest, then I choose Excel File and I rename sheet 1 to name ...
6
votes
3
answers
764
views
How to write script to kill MS Office database locks in MSSQL
I've recently inherited a MSSQL database as our DBA has moved on to greener pastures. I'm not a DBA and have limited to moderate SQL knowledge but have had to absorb some of his duties and have an ...
- 61
1
vote
1
answer
136
views
Upgrading from excel to an actual database
Just started my first internship and I could use some guidance on approaching the project given to me. Simply put, all that needs to be done is to make a database and then transfer the data from a ...
- 11
-2
votes
3
answers
6k
views
Automate SQL Server reports and send them by mail
I work in a large retail business with a decent SQL Server environment.
We have SQL Server replication, Availability Groups, Data warehouse, and some cloud services. In this beautiful environment, we ...
- 45
-1
votes
1
answer
151
views
Sometimes, not always, when loading an MSSQL table from Excel a new table suffixed with a $ is created by MSSQL. Why?
We are loading MSSQL tables via Microsoft Management Studio Import. Sometimes, not always, a new identical table is created in the load process with a $ at the end of the name. Why does this happen? ...
0
votes
0
answers
397
views
How to transfer data from one table to another with exception handling in Postgresql?
So, I have two tables, one where I import data from an excel file all in string format without considering any sorts of constraints or data type validation. And then the data is transferred to the ...
- 111
0
votes
1
answer
67
views
Consolidate / sort / combine / merge data for dummies
I am looking for a non-scripting solution to combine data from 3 different tables (preferably using spreadsheet software like Microsoft Excel but a database would also work e.g. Microsoft Access). I ...
- 103
1
vote
1
answer
445
views
Running Excel addin for MDS2019 vs MDS2016
We are upgrading master data services (MDS) of SQL2016 to SQL2019.Is there a way to run excel 2019 addin for connecting to SQL 2019 MDS along side(parallely) with excel 2016 addin for connecting to ...
- 143