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.

I am developing software in vb.net for sales invoices. Where I need to import invoice data from excel file to vb.net Grid Data View and then save into access DB. I will use DB data in the future for ...

One of my company's SQL database generates a lot of deadlocks per day recently (someday >100)
I'm trying to troubleshoot the causes of these deadlocks, i noticed that many deadlocks occur at the same ...

I have an xlsx file with content in the form of a database table - first row is column names, and columns contain varchars2, integers etc.
Since VBA and Excel worksheet functions are too slow for it, ...

I have a 40gb csv file with over 60 million rows for data analysis. Each row has a unique identifier (some numbers). For example, the first row's unique identifier will repeat approximately 150,000 ...

I am trying to import huge data without any data loss from excel sheet to SQL Server. The excel sheet has few columns with mixed data types and few column with dates. I have prepared a sample file as ...

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 ...

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 ...

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.
...

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 ...

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 ...

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....

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.
...

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....

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 ...

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 ...

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 ...

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 ...

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 ...

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, ...

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 ...