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

learn more… | top users | synonyms

6
votes
1answer
669 views

Can someone explain the magic of Opendatasource/Openrowset?

When pulling information from an excel file (or ms-access DB) I commonly use something like this: SELECT * FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0', 'Data Source=C:\test.xls;Extended ...
5
votes
1answer
190 views

Schedule Query and Export

Is it possible, to schedule a simple Query to run Daily and export the received data into an excel file?
5
votes
1answer
897 views

SSAS Cube in Excel - Show only applicable rows with KPI?

I have a cube built in SSAS 2008r2. I'm exposing it for the moment through an excel PivotTable. I recently added a KPI to the cube, and when I show the KPI in my PivotTable interface it causes ...
4
votes
1answer
1k views

Importing a large column (8000 chars) from Excel using SSIS

I'm trying to set up a regular import of an excel spreadsheet that we get from a vendor. I'm using SQL 2008 R2 SSIS to import it into a table. The problem connection manager is an OLE DB connection ...
2
votes
2answers
63 views

Is there a better way than the ones listed within to join data in an excel spreadsheet to a table in a SQL Server database?

Let's say I'm given a list of names and email addresses in an excel spreadsheet. I am asked to find all customers in the database who's name, and email are in that list. I currently know of two ways ...
2
votes
1answer
1k views

How to avoid empty rows in SSIS Excel Destination?

Does anyone have a way to avoid empty rows when using SSIS to export to Excel. Here's a simple example of one data flow task: OLE DB Source: Data Conversion (to handle the annoying UNICODE / ...
2
votes
1answer
531 views

excel sheet input to mysql

I want to add about 1000 records to a table that contains 31 fields. The worst part is those 1000 records are in the form of an excel sheet having some columns left unfilled. Is there any easy way to ...
2
votes
1answer
1k views

Informatica Source Qualifier not working from Windows ODBC data source (system DSN) from Excel xlsx file

Reference: https://community.informatica.com/message/62128 Windows ODBC Workflow: Windows > Control Panel > Administrative Tools > Data Sources (ODBC) > click "System DSN" menu > click "Add" > ...
1
vote
2answers
2k views

Exporting data to excel

I want to execute some stored procedure and I want to export that result to Excel. How can Do that ? I'm new to SQL. any help or tutorials about this will appreciated.
1
vote
3answers
485 views

EXCEL sheets batch input to Access

I have a lot of Excel datasheet (in one file) I want to batch input to Access but I can't find a sample code to do it the name of datasheet in access is same as in excel is there any code of ...
1
vote
2answers
1k views

Is there a free software that can import excel into mysql on mac?

not csv format files, but .xls or .xlsx format excel files, is there any free software for mac, that can import data into mysql?
1
vote
3answers
1k views

Create/Delete file using SQL Server 2008

I have an Excel file in C:\testing.xlsx. I am exporting data from my database table to Excel using [OPENROWSET (Transact-SQL)]1 method. Now I want to clear or delete all rows in my Excel file by ...
1
vote
2answers
251 views

changing a range into discrete values for a field in oracle

I have a data table that contains records like this: ZIP Ground Air 010-041 005 305 150-163 004 304 As I have it right now, it's actually an excel file but I eventually need to ...
1
vote
2answers
2k views

Update existing data with excel import

I have user table in my DB. I have 1 excel sheet having list of some users (not all) with changes. How can I Update the values given in excel sheet to my user table? is it possible with import data ...
1
vote
1answer
1k views

OPENROWSET can't import an excel spreadsheet into SQL Server 2005 Express

I am trying to run the following query to select data from an excel spreadsheet: SELECT FT_ID_SOCIETE_FF2C,FT_NOM,FT_ADR1,FT_ADR2,FT_ADR3,FT_CP,FT_VILLE,FT_TEL,FT_FAX,F10 FROM OPENROWSET ...
1
vote
0answers
721 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
149 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
230 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
1answer
81 views

Suitable database software for small business [closed]

First of all, I apologise if this is in the wrong area. I'm looking for a suitable database program for a small engineering business, which needs to log various jobs. Currently, we're just using an ...
0
votes
2answers
29 views

SSIS and Excel import

I am using VS2012 and creating a package on a 64bit machine to import some data from a .xlsx file. My question is that I am getting an error for the Excel connection manager, do I need to install ...
0
votes
1answer
61 views

SQL Server error importing an Excel sheet

I am facing a problem while loading & importing an Excel sheet into a SQL Server database. The error is The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an ...
0
votes
2answers
335 views

Import batches of rows from Excel in parallel

We receive an Excel file weekly currently containing about 250k rows. The file grows by about 300 rows each week. In SSIS I've hooked up an Excel source to an OLE DB destination to import the file ...
0
votes
1answer
14 views

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

So I'm trying to copy and past 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
0answers
29 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
41 views

Help with SQL Server Error “ad Hoc access to OLE DB Provider 'Microsoft.ACE.OLEDB.12.0'”

So we have an interesting issue where users are receiving the following error when attempting to query a view in SQL Server 2008 R2: Msg 7415, Level 16, State 1, Line 1 Ad hoc access to OLE DB ...
0
votes
0answers
56 views

Problems using “Excel PostgreSQL Import, Export & Convert Software”

I want to export data from Postgresql, and I tried many ways then find the tutorial of Excel PostgreSQL Import, Export & Convert Software on Youtube. I installed the software, but I could not ...
0
votes
1answer
278 views

SQL Server 2012 error when exporting to Excel

Let me start off by saying I know little and less about SQL. I received a .bak file from a client earlier today and they want me to move it to a new database (not SQL). I've created a SQL Server 2012 ...
0
votes
0answers
12 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 ...
0
votes
0answers
76 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
93 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
109 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 ...
-1
votes
1answer
282 views

SSIS SQL Result to tab delimited txt file [closed]

I have created a package that Runs a Sql Query and then puts the results into a flat tab delimited txt file. When I opened the flat file in excel everything was in the right columns but in columns ...