Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X.

learn more… | top users | synonyms

0
votes
1answer
38 views

MySQL reads Date columns in Excel as DateTime?

I'm trying to export Excel sheets to MySQL as new table using the plugin. The export fails on "MySQL error 1064" when I tried to change the data type to Date. I have a few columns in Excel that are ...
1
vote
0answers
20 views

SSIS: Is it possible to process excel file with dynamic column headers

SSIS: Is it possible to process excel file with dynamic column headers. For instance: Excel file has 5 columns and we process that and save data in a table for all the 5 columns. Now, the scenario ...
0
votes
0answers
14 views

Generating a formatted Excel datasheet from Access data [migrated]

The title basically sums up my question. Essentially I'd like to generate a formatted excel sheet from access table data with the click of a button in my form. I know you can export access data to ...
0
votes
1answer
20 views

SQL export select statement to Excel using script

I have a project that requires me to create a script for migration between test and live data-bases. What i want to do is create an extract from the test database into an excel sheet or a txt file ...
1
vote
1answer
39 views

How to convert .rda database to excel workbook

I have downloaded a database with .rda extension, unfortunately I don't have oracle program. How can I convert .rda database to excel?
0
votes
1answer
68 views

Linking between SQL Server and Excel [closed]

I want to dump Excel data in SQL Server database. What is the best/easiest way to do this? I have SQL Server 2012 Management Studio. I have tried many techniques but failed miserably, there is no ...
1
vote
2answers
97 views

Create a monthly job to export from SQL Server 2014 to Excel

There are a lot of questions here asking "how to export from SQL Server to Excel", but every answer, together with stuff I know, is giving me problems (64bit system here). We have a developer that ...
0
votes
1answer
27 views

Powershell: Does System.Data.SqlClient.SqlDataAdapter usange in powershell need some ADO.Net installation?

In PowerShell, goal is to query some data from Sql Server and put that into a preformatted Excel file. Towards that, the following PowerShell script snippet, throws an error saying "assemblies are ...
0
votes
0answers
101 views

automate import and export of process EXCEL -> SQL SERVER - > EXCEL without using SSIS

I have an ETL process that is entirely written using T-SQL scripts. The script grabs an Excel spreadsheet and imports it using openrowset. Once I get the transformed data I copy with headers and paste ...
0
votes
1answer
32 views

What are the minimum requirements for running a dtsx package on a PC?

One of my clients has some very specific needs to get a spreadsheet run through some ETL processes I have created. I have developed an SSIS .dtsx package which imports an Excel spreadsheet into SQL ...
0
votes
0answers
33 views

SSIS Package Not Populating Excel Correctly

I have an SSIS package that populates the details tab of an excel file. Once it is populated there are two pivot tables that derive data from them. I made a change to the Excel file to add two new ...
0
votes
0answers
35 views

Update MS Access table from Constantly changing Excel Spreadsheet

I have an excel spreadsheet that looks something like this: modelNum | serialNum | Data ------------------------------ 478389 | 1Z431G | 4 478389 | 1Z43A1 | 6 438584 | ...
1
vote
1answer
34 views

SQL db2 remove specific item from the query

Can you please help me out with the below query? What I am looking for is a code to exclude items with wording '90003' from column COR_ID. So far I have a code that extracts data with date older than ...
0
votes
0answers
48 views

Importing Legacy Files directly into SQL Server database

I have a bunch of flat files, mostly Excel files, which I am trying to import directly into a SQL Server 2012 database. Is there a way to do this? I assume first the columns in the Excel files must ...
0
votes
1answer
71 views

SQL Anywhere 12 - exporting data to Excel

Do I need to install MS Office Excel on machine where is SQL Anywhere 12 server for below code to work? Or SA 12 or Windows have MS Excel Driver builtin? SELECT * FROM SalesOrders; OUTPUT USING '...
0
votes
0answers
59 views

Microsoft Access - Use table from excel to update all other tables in a database

I am working with a database on Microsoft Access 2016 in a small company. What I would like to do is create a table (imported by Excel) and update all related fields in the other tables. The Excel ...
0
votes
1answer
30 views

Accessing Registered Servers over Excel

With DBs in different countries, different servers but same structure, I have created registered server to access them when running certain queries for reports on SSMS. Thus far this is ok. However, I ...
1
vote
1answer
48 views

Question regarding Excel connection to SSAS cube

Looking for a way to change the connection in an existing spreadsheet from old SSAS server to the new SSAS server without losing the data in the spreadsheet. Hardware refresh has made this change ...
1
vote
0answers
48 views

SSIS package with changes to Excel file

I have an SSIS package that loads up an Excel file on daily bases; from time to time the file changes. It can have additional columns in the Excel worksheets. How can I know if the Excel file has ...
3
votes
2answers
236 views

How to read an excel file from a network machine using SQL?

I am trying to import some excel file data into a SQL table. I thought of using OPENROWSET for this. The issue is that the csv file is location in a different machine in the same network. How do I ...
0
votes
1answer
623 views

How to load Excel file into temp table in ORACLE

Is it possible to load a excel file with the headers into a temp table on Oracle? I use TOAD for the interface. I am needing to do some comparison on a a excel file with what we have in our database....
5
votes
4answers
253 views

Compare each column in a row and return an error if any of them is different

I'm attempting to find any identifiers with any values that are different in the same row. +------------+--------+--------+--------+--------+ | Identifier | Value1 | Value2 | Value3 | Value4 | | f001 ...
4
votes
3answers
109 views

is automated data movement via Excel considered ETL?

I am wondering if informal methods of automatically extracting, transforming, and loaded data constitute "ETL." For example, I code Excel VBA to extract from databases onto a spreadsheet, transform ...
0
votes
1answer
97 views

How does one create a data base for a survey/questionnaire? [duplicate]

I need to create a database for a wordy questionnaire. At the end I want to be able to graph my information. Where can I do this?
3
votes
2answers
751 views

Best way to export excel table into MySQL db

I'm trying to export an Excel table which contains about 400 records of HR stuff (e.g. name, surname, age, job, ecc.) into a MySQL db. I'm actually using mysql for excel and started reading a db book,...
1
vote
1answer
261 views

SSIS Run Excel Macro Error

I have an SSIS package that populates an Excel file. The package is run from a SQL Server Agent job. It all runs fine, but now I have added a Macro to the Excel file. This macro causes the Package to ...
0
votes
0answers
22 views

Query to get result in Excel file [duplicate]

The following query gives me the error Incorrect syntax near 'OUTPUT'. SELECT * FROM dbo.sales ; OUTPUT USING 'Driver=Microsoft Excel Driver (*.xls); DBQ=c:\\test\\sales.xls; READONLY=0' INTO "...
0
votes
1answer
106 views

Is there a database tool that bashes data with HUGE excel files?

Ok this is hard to explain and im not sure if this is the right place to ask it but. Im 2 weeks in on my new work and I feel like our work can be a lot more easier if we dont rely on just Excel for ...
2
votes
1answer
782 views

Query SQL Server from Excel with parameters linked to cells

I have a bunch of Excel spreadsheet that have data connections to a SQL Server DB (Hosted by AWS RDS) and I follow exactly this procedure to get those connections up and running with the parameters ...
0
votes
1answer
111 views

One time data conversion in Oracle tables with excel data

First of all I have very basic knowledge in back end I need to do an one time data conversion in an Oracle table with a excel sheet data. Excel sheet have data in below format OldData NewData ...
0
votes
1answer
166 views

Why do the queries slow down after a few minutes, when trying to build a DB?

First - I am a complete newb to DBA. Please be gentle. (And I am fairly new to python as well.) Oh, and I have no idea how to change any MySQL settings or the like, so all the MySQL DB settings are ...
2
votes
0answers
119 views

Microsoft Access Export to Excel

I have an Excel spreadsheet that is filled with a ton of data which is organized by column (a column for names, a column for occupation etc.). I have recently moved all of this data into Microsoft ...
1
vote
1answer
310 views

SQL errors Microsoft.ACE.OLEDB.12.0 on dev box, but works on server

I'm inserting into a .xls spreadsheet from TSql code. Runs fine as an Agent job and on command from the server, but not on my dev box. Both complex and simple commands like: Insert into ...
0
votes
1answer
3k views

SQL Developer - trying to import an excel file into a table

I'm trying to import an excel file into a table. The excel file has dates in the following format: 20/08/2008 12:00:00 AM and I am telling SQLDEV the following: DD/MM/YYYY H24:MI:SS AM To import the ...
-1
votes
3answers
1k views

Pasting data from Excel table takes very long [closed]

I use SQL Server Management Studio 2012 to import data from Excel sheet to a table on SQL Server. I use the most straightforward way that I just Ctrl+C a table in Excel and Ctrl+V in table edit window ...
1
vote
0answers
307 views

Excel and Oracle SQL Connection

I am connecting to an Oracle DB and return data with Excel 2010. I have setup the connection in my workbook and my connection string looks as follows, Provider=OraOLEDB.Oracle.1;Password=jasonpc;...
1
vote
1answer
125 views

How can I append new data from a particular mySQL table to an excel spreadsheet?

We have a database trigger that automatically adds new clients to a table when they first contact the server, it takes a number of unique identifiers that the client provides on first contact and ...
1
vote
2answers
149 views

Overwhelmed with Sensor Data - Excel to SQL Server fails

I'm managing a lot of sensor data and need to do charting, smoothing, stats over time on the data. Currently I import the data from flat files using VBA to do ETL into Excel. The format of the data ...
1
vote
1answer
1k views

Correct 'lines terminated by' for query

I am trying to query two tables of data and send them to a csv file for upload to a website. However i am having trouble getting the formatting to play ball. I want headings to separate into columns ...
0
votes
1answer
4k views

Excel Data Connection to SQL Server using Windows Auth from untrusted machine

We have an Excel spreadsheet that uses a Data Connection to a SQL Server database. The database server is joined to our domain, and Windows Authentication is enabled. Here is a sample of the ...
1
vote
2answers
357 views

Excel spreadsheet into a MySQL database tables

I am relatively new at database design and would like to get this right from the start. I have had differing advice on how to do this and believe that the common suggestion of importing all the data ...
3
votes
0answers
203 views

Sql Powershell Script not working [closed]

I am performing a job from SQL server agent with a powershell command. It was running fine a couple of days back.. there is no change in the script. The script is also working fine if i run it via ...
0
votes
1answer
129 views

Convert an interaction matrix into a ternary relation

I have what I'm calling a sparse "interaction matrix" of data in MS Excel that I wish to convert into a "ternary relation" (table) in Access. The spreadsheet data are in this pattern: Name Act-1 ...
0
votes
1answer
249 views

AD group cannot connect to SQL from excel

We have a data warehouse and users are trying to browse the database directly from excel. We put those users in an AD group and give them read only permission to a couple of databases. The problem is ...
2
votes
2answers
1k views

SELECT permission denied trying to import data into Excel

We recently migrated to a newer version of a program and migrated its database from SQL Server 2000 to SQL Server 2008 R2. We had some Excel files which ran a few custom queries to pull data. I ...
2
votes
3answers
3k views

How to handle big data update based on excel spreadsheet

Scenario Select-based data is exported from DB to Excel spreadsheets. Some manual work is done on the excel files (filling missing data). Changed data from excel files is updated back to DB. ...
1
vote
0answers
386 views

Exporting to excel from OPENROWSET with cell formatting

I am trying to generate a report from SSMS to Excel, using OpenRowSet. All is working fine, still I have to export a specific column with a barcode font. I already have the column calculated from ...
1
vote
2answers
571 views

01/01/1753 date is corrupt in Excel after export from SSRS

The date 01/01/1753 appears fine in the SSRS 208R2 report preview, but when the report is exported to Excel 2010, it appears as ########### and the value in the cell is -53689. All other dates come ...
3
votes
1answer
63 views

Wich is the most efficient/easy way for end-user to get data from Analysis database?

I know that you can quey a cube by connecting from excel to Analysis database and using formulas like cubevalue() or cubemember(). I also know that after converting the power pivot to formulas you can ...
-1
votes
3answers
741 views

How to load multiple values in cell from Excel to SQL Server many to many table [closed]

I have values in excel like this. StudentNumber| Subjects 1| english, science, maths 2| maths, biology 3| history, zoology I have Student table in database ...