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

learn more… | top users | synonyms

2
votes
1answer
451 views

Slow Performance of Parametrized Query in Excel due to Parameter Datatype

I'm pulling Data from a SQL Server 2008 into Excel using a Parametrized ODBC Query created by the Excel Wizard. (Data-->getExternalData/FromOtherSources-->FromDataConnectionWizard-->ODBC DSN) My ...
1
vote
1answer
43 views

Overwhelmed with Sensor Data - Excel to SQL 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 ...
0
votes
1answer
118 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 ...
0
votes
1answer
52 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 ...
0
votes
1answer
293 views

Copy+Pasting currency value from SSMS 2012 to excel does not complete or calculate new value

So I'm trying to copy and paste some query results into Excel, and for some reason it seems to be not properly completing the first value. Let me explain what I mean by this. In Excel the cells I am ...
0
votes
1answer
37 views

Export database in one file with every dataset existing

I've got a unusual question. The human resources needs to export an old DB to a new one. And the guys managing the new DB wants one csv file with every dataset existing. I did a Relational database ...
1
vote
0answers
75 views

Sql Powershell Script not working

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 ...
1
vote
0answers
129 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
0answers
3k views

An error was encountered in the transport layer - SSAS 2012 from Excel 2013

When connecting to an SSAS 2012 tabular model from Excel 2013 (Data... From Other Sources... From Analysis Services... fill in Server Name... click Next), I get the error: An error was encountered ...
1
vote
0answers
286 views

How to aggregate calculated measures involving dimension attributes?

The business case is as follows - I have a cube of sales transactions and a dimension of parts. One of the attributes of a part is the current cost, which is non-aggregatable. A user needs to model ...
1
vote
0answers
332 views

Update excel sheets from SQL Server 2005 linked servers

I use SQL Server linked servers to connect to Excel 2003 multiple tabs workbook. After connected, I have not problem to use select statement like: select * FROM OPENQUERY(TEST, 'select * from [fist ...
0
votes
0answers
13 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, ...
0
votes
0answers
22 views

SQL Server - How to set multiple variables from excel spreadsheet?

I have a spreadsheet of 4 columns as shown. What I want to achieve is this: update apodetail set status = 'O', cur_amount = 'VAR1', rev_price = 'VAR1' where order_id = 'VAR2' AND line_no = 'VAR3' ...
0
votes
0answers
128 views

Moving results from an MS SQL query in Excel - line breaks in data

I select all the output from my query by clicking in the left upper corner in the MS SQL Server Management Studio results window. I right-click, then select "copy with headers." Then paste into ...
0
votes
0answers
33 views

Show Oracle data in Excel

Is it possible to set up a service such that people in an office can use custom formulas in Excel to show values from an Oracle database. Example 1: User types: "=ORA_BALANCE()" and the service ...
0
votes
0answers
204 views

Pasting into PHPMyAdmin

This is probably really simple but I have had a look on the web but can't seem to find an answer. I am experimenting with MySQL + PHPMyAdmin on a WAMPserver stack and was saving queries in Excel When ...
0
votes
0answers
523 views

SQL query to return a column per date in date range with sum of contract utilisations (value/duration)

My question is similar but more elaborate than another already in stackexchange.com "SQL query to return a column per date in date range?" I have the following data: Customer Start_date ...
0
votes
0answers
123 views

Replicating Excel's CHIDIST function in Oracle 11g

I'm attempting to replicate the functionality of an Excel workbook in Oracle. One of the formulae on the worksheet uses CHIDIST, which "Returns the one-tailed probability of the chi-squared ...
0
votes
0answers
162 views

Passing parameters through Excel to an Informix DB works through MS Query but fails when returned to Excel due to General Error

I require to query an informix database using parameters and Excel. When the query is executed in Microsoft Query the dataset is fetched and returned succesfully, when I attempt to return to Excel the ...
0
votes
0answers
133 views

GUID for temporary table ADO

this is what I am trying to do. Frontend: Excel Backend: SQL server, or mySQl In excel, I create an array, this array I want to pass into either a temporary cache table or into a new table in a ...