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.
0
votes
1answer
32 views
I gave 3 large Excel files need to be loaded in Single SQL table
I have 3 large Excel files each sized 56896 KB, I need to load all 3 files into same SQL table. what is better way to handle?
since My excel has more data, my excel hang up when I open and search any ...
2
votes
1answer
11 views
Excel / MS SQL Server: Exception of type Microsoft.Office.PowerPivot.BackEnd.StorageException
We have an Excel table that gather data from our datawarehouse db on a SQL Server 2016. It queries a relative simple view to find the top customers of the last few days (including some aggregated ...
1
vote
1answer
33 views
Excel grab data from MS SQL Server with WHERE clause based on cell contents [closed]
There's a bunch of questions for similar things, but I've been unable to find anything that fits.
We have three columns:
Name | ID | Cost
Thingy 3 25
Other 11 ...
0
votes
1answer
27 views
Are iSeries AS/400 (DB2?), Lotus 1-2-3, and Excel date/time formats the same? [closed]
Are the formats for dates/times from AS/400, to Lotus 1-2-3 that carried over into excel...with the date being the number of days since 1900-1-1 when mistaking 1900 for a leap year as an integer, and ...
0
votes
0answers
11 views
what is the Usage of Tabular mode in SSAS? Should I use Tabular to see Excel data
I have 3 excel files each around 56896 KB. Users use the data in excel for some reference. Now they use the Excel Manually, since Excel has exceeded its size, when they search it hangs up. What is ...
0
votes
1answer
29 views
Import data from excel to table in sql
Please I have issue that when I try to import data from excel to table in SQL it fails with below errors even I modified all the tables in the tables to be nvarchar(max) and I tried to enter dummy ...
0
votes
0answers
24 views
Postgresql function equivalent to Excel's NORMSINV function?
I need Excel's NORMSINV equivalent function for PostgreSQL, preferably plpgsql function. Can somebody help?
For reference, here is Excel's normsinv function explained:
https://support.microsoft.com/en-...
0
votes
1answer
28 views
Excel Values Uploading as NULL to database [closed]
I have an Excel file in which I have many records. When I upload this file to a table in a database (SQL Server) some values save as NULL even though the Excel file does not have NULL or blank fields.
...
-2
votes
1answer
81 views
SQL query for import data [closed]
How can I write a single line SQL for importing 20k rows data from Excel to SQL server ?
Please don't tell me about import export wizard or to write 20 line repeatedly for do the same.
Please tell ...
1
vote
1answer
34 views
Excel query execution status
I have inherited this huge Excel file that has a connection to the database and it will retrieve data on opening. This file is huge and it takes a long time to update (hours) and I'd like to know ...
-1
votes
1answer
569 views
Foreach Loop Enumerator with multiple File Names
I have a directory like C:\NewExcelFile in which I have lots of different Excel files with different names (but with the same extension .xlsx). I have a "foreach loop enumerator" in my package which I ...
0
votes
2answers
171 views
Different calculations in EXCEL and TERADATA SQL
The calculation select (75/979.86)*979.86 in Teradata SqL gives 78.3888. In excel, it would give 75 simply and that is logically correct. I get it that SQL is rounding off 75/979.86 to 0.08 ie the ...
2
votes
0answers
48 views
Export table from MS Access to Excel while retaining Field Name and disregarding Caption
I have a MS Access Database, with each table containing the data of a particular questionnaire. I am building data entry forms for each of these tables, but as the field names may prove to be ...
1
vote
0answers
74 views
OPENROWSET error accessing XLSX if not manually saved
Good day,
Apologies if this is in the wrong forum. Please refer me to the correct one if this is the case, thank you.
I have a bunch of excel files that are added to a Dropbox folder on a monthly ...
1
vote
1answer
2k views
The EXECUTE permission was denied on the object 'SPROC', database 'DATABASE', schema 'dbo'
I have a few users that are unexpectedly receiving this error message today when they attempt to refresh a stored procedure via Excel:
The EXECUTE permission was denied on the object 'SPROC', ...
0
votes
1answer
290 views
How to correct SQL Server Import and Export Wizard error that says my data conversion length must be between 0 and 4000?
The message I get from the 2017 SQL Server Import and Export Wizard which I need help with is,
"Error 0xc0204016: SSIS.Pipeline: The 'Data Conversion 0 - 0.Outputs[Data Conversion Output].Columns[...
-3
votes
1answer
342 views
Database name 'mydb' ignored, referencing object in tempdb. Bulk Insert
I'm trying to insert data from an xlsx file into my temporal table. I've also tried with a real table, but it throws me the following error:
(0 rows affected)
I'm pretty sure my error is in the ...
0
votes
3answers
507 views
Transfer data from Excel to table
How can I transfer information from an Excel file to a table in a SQL server database through SSMS?
Excel file Consists of five columns and a thousand rows.
I followed the steps as explained here,at ...
0
votes
2answers
49 views
Concurrent connections to the same table
We are a small firm, with about 10 people using a database server.
I have this application that connects to a database and fills about 40 rows of data in an table. Then calls a stored procedure to ...
0
votes
1answer
2k views
How can I merge data from an Excel file into an access database with multiple tables? [closed]
I have an access database with many internal tables.
Each table is a category of electronic components (resistor, capacitor etc)
In all tables, there is a manufacturer part number and a currently ...
1
vote
0answers
266 views
Sqlserver cannot write large text to excelfile with ACE, using IMEX=1, result=object is read-only
I have a table Test with column id (int) and column label (varchar(512)) and an excelfile test.xlsx with sheet test and the two columns. I use the ACE-provider to write from sqlserver to the excelfile....
0
votes
1answer
24 views
Designing a database for Reading Comprehension
So I am building an RC app that will require me to fetch data.
I have data in Excel sheet and I would like to load the data in sqlite database. But I am having trouble designing the db.
A little ...
0
votes
2answers
53 views
Extracting data from Excel files
How to extract data from spreadsheets or Excel to database using terminal in Ubuntu?
I'm using MySQL in Ubuntu and now I have 3 different Excel files using which I need to create a database in SQL.
...
-1
votes
1answer
81 views
Creating Excel Spreadsheet with Database Table information
My Goal:
I'm wanting an excel document showing basic information for each table. I'd be happy with the same information shown when you Alt+F1 on the table but ideally I want a separate sheet per table....
1
vote
2answers
1k views
64 bit Machine 32 bit Excel Using SQl Server Management Studion V17
I am using the below sql command to import an excel file (created in excel 2016) into SQL Server Management Studio on a 64bit Machine with 32 Bit Office.
SELECT *
FROM OPENROWSET('Microsoft.ACE....
0
votes
1answer
104 views
Exporting an Excel Spreadsheet containing a pivot table and charts to MySQL
I am looking at moving a large Excel spreadsheet to an SQL database - most likely MySQL.
The excel spreadsheet contains 12 worksheets, with one of them being the Master, and the other 11 set up to ...
1
vote
2answers
316 views
SSIS ACE.OLEDB.12.0 Driver issue
We have a SSIS package which is using a Excel destination. It was brought to my notice that the job was failing with the common error message 'Microsoft.ACE.OLEDB.12.0' is not registered. I checked ...
2
votes
0answers
2k views
Opening a rowset for “Sheet1$” failed
I am using SSIS to export an Excel 2007 file to a SQL table. When I execute my package locally it works; however, on the server I get the following error:
Data Flow Task:Error: Excel Source failed ...
1
vote
2answers
133 views
Pulling SQL Server data into Excel
I'm trying to pull data from an SQL Server database into Excel 2016 via ODBC / Microsoft Query (built in to Excel).
I'd like to have a dropdown of companies, where after a company is selected from ...
2
votes
1answer
2k views
Excel Query Using MariaDB ODBC Driver
I'm using MariaDB ODBC driver version 3.0.2 for Windows(on Windows 10) and can't get excel (Excel 2013) to query the database. I'm able to connect to my MariaDB server using HeidiSQL and query just ...
1
vote
3answers
4k views
SQL Server: SSMS “Save Results As” creates CSV that Excel mangles
Using the Save Results As option, shown below.
CSV looks good!
But when Excel opens/imports it:
Long strings are mangled as numbers (if the data is largely numeric)
Dates are not detected properly
...
0
votes
1answer
170 views
MS-excel not accepting postgresql server certificate
I am trying to connect my MS-excel to postgresql 9.6
Firstly, It gave me error that it does not have the required library. So I downloaded ngpsql.
After that, it gave me error that it cannot accept ...
4
votes
2answers
551 views
Why is this SSRS Report rounding a BIGINT Value to the nearest Thousandth when exporting to Excel?
I have a SQL Server Reporting Services (SSRS) 2012 report that is populated via stored procedure (SP). The SP returns various fields, one of which is a BIGINT datatype. When I execute the SSRS ...
0
votes
1answer
542 views
Updating SQL table from Excel sheet (using powershell)
I am using the below code to complete a bulk import into SQL, but I think I have run into a problem with my method.
$serverName = "pjim-app-02\tsg";
$databaseName = "User_Data" ;
$tableName = "dbo....
1
vote
1answer
381 views
High ASYNC_NETWORK_IO when user locks computer with Excel open
I have a user who gets in at 8AM and leaves at 6PM every day, and every day I see the same strange pattern in SolarWinds DPA.
It seems that Excel is refreshing the Query Table when the user locks ...
2
votes
1answer
334 views
Altering SSAS writeback behavior?
I'm trying to implement a writeback measure group for required quantities by month and part number. I'm puzzled by the behavior I am seeing in Excel 2013, but I don't know if SSAS or Excel is ...
1
vote
1answer
19 views
Need to find a pattern in SQL Data base and then write a query to delete the duplicate “NULL” Value
I have read a lots of stuffs regarding this but cannot find solution to this problem. Please some one have a look into it.
I have a unique data-base, which contain Row-number, Year, Practice, office ...
-1
votes
1answer
686 views
Problem with MS Excel MDS addon - unable to connect to the web app
I have a new installation of MDS and SQL Server 2016. Installed the Excel plugin too, but unable to connect to the web app. I keep getting this error "there was no endpoint listening at <> that ...
1
vote
1answer
2k views
SQL Server Import Wizard Excel into SQL Server 2016 Error 0xc020901c
I am trying to import an Excel file with 3914 rows of data into an existing table on SQL Server 2016 Express through the SQL Server Management Studio. I imported a similar file last month, but this is ...
2
votes
0answers
3k views
inserting data in temp table with read only database access [closed]
I only have read only access to my company's database (no chance of getting write) and want to import Excel data to a temp table, is this possible?
I can create temp tables tied to just my computer, ...
1
vote
0answers
520 views
SQL Server opendatasource reading a password protected Excel file
I would like to read a password protected Excel workbook and I'm not sure what the syntax is to enter this parameter.
I found only passwords for the connection, which is not needed due to login.
I ...
0
votes
1answer
103 views
Ms-access defining additional Index Fields
I am developing an access database that eventually will grow in size. For that reason scalability has to be taken in account.
My background: no official studies about databases.
I have read Access ...
0
votes
1answer
521 views
Connect excel to ms-access front end database
I have an access database split. It is part of an app working along with an excel add-in.
Question:
Within excel, should I address all query updates directly to the back-end version (in the shared ...
1
vote
2answers
386 views
Importing from Excel
I am attempting to import excel sheets into SSMS and I am having trouble with data types. I was running into problems with columns with both text and numbers in them. I want these columns to import ...
1
vote
1answer
70 views
Can I lookup my Primary Key in SQL Server from Excel Spreadsheet?
Disclaimer: I'm a database novice teaching myself for a research project.
Background: I am querying an electronic medical record (EMR) system for information pertinent to my project and I do not ...
3
votes
2answers
889 views
PostgreSQL: alternative ways to connect to database
THIS IS A THEORETICAL QUESTION. I am posting it on this site because of this and because I think that database administrators could provide more accurate insight. The line that separates the two sites ...
0
votes
1answer
1k views
vba Excel data Validation error 'Application-defined or object-defined error'
I've read loads of similar questions and answers, but keep getting error.
What I do is I export query via
DoCmd.TransferSpreadsheet acExport, 8, "blabla", outputFile, True
Then I'm attempting to ...
1
vote
1answer
524 views
Updating Properties of an Excel cell, with Sql statement
So far, i have constructed a SSIS Package that creates multiple Worksheets in an Excel Speadsheet and populates it with values (Reports).
Then I can Execute a SQL statement, via SSIS, to selectively ...
1
vote
2answers
2k views
comparing two values in same column with another column using AND condition
Column A is MOBILE NO.
Column B is Agent Id calc
MOBILE NO Agent Id
7024226667 A1EXF8ZF unique
7042004489 A1XKV3J1 unique
7042004940 A1JA23X1 unique
7042005480 A1UFIHOD ...
1
vote
1answer
2k views
SSRS --> .xlsx file --> SQL ETL — “External table not in expected format” error, but only when files have not been opened
Long story short, I've had to use a workaround to importing data directly from SharePoint due to SSIS drivers not working with it. My current workaround is almost good enough, but it still has some ...
