0
votes
1answer
36 views

Strategy for Incremental Datasource fetchings in Excel

I am in an scenario with a table that is refresh by a third app every week. I need to keep accumulating all data in Excel, using an ODBC connection to the database. I am wondering Approach 1: Is ...
0
votes
0answers
82 views

Use Excel to query Sybase database

Excel offers the ability to connect to external data sources. I am told I can connect to a Sybase database to import some data into excel from a query. How do I do this? I have the following: Query ...
1
vote
1answer
92 views

Stubborn “Read-only” notification in Excel won't go away

I have a table in Excel that includes a set of cells copy-pasted from a TFS bulk edit worksheet. I'm usually careful and paste values only so that I don't get any of the data validation, etc. I'd like ...
1
vote
1answer
24 views

Excel 2010 - Large Practitioner Database Consolidation

I have a database of 1800 employees (1 employee per row) and a binary confirmation of whether they have 1 or more of the 105 professional certifications we track (1 certification per column). I ...
2
votes
1answer
112 views

Easy way to put multiple columns in Excel on their own rows?

I have a sheet that looks like this: A | B | C | D | E | ---------------------------------------- 62| Value1| Value2| | | 345| Value3| Value4| Value5| ...
1
vote
0answers
568 views

Is it possible to add a data connection to an existing table in Excel?

I have a table in Excel which has a data connection to an Access database. When the data changes, I can click "Refresh" to re-query the data and update the table. However, Excel 2008 for Mac doesn't ...
2
votes
1answer
5k views

How do I extract excel data from multiple worksheets and put into one sheet?

In a workbook I have 7 sheets(Totals and then Mon to Sat),I want to extract rows which have the word "CHEQ" in its cell (this is a dropdown list with two options-CHEQ/PAID)from all sheets. On my front ...
0
votes
3answers
1k views

How may I retrieve data from an Excel table based on a variable number of criteria?

I have the following salary data for example: Country State 2012 2013 -> 2027 ======= ===== ==== ==== China Other 1000 1100 China Shanghai 1310 1400 China Tianjin ...
0
votes
1answer
418 views

Is there an easy fix to this copy/paste into Excel error?

When I attempt to paste a large spreadsheet (from a DB, ~90,000 rows) into Excel, I keep getting this error: Microsoft Excel is waiting for another application to complete an OLE action I ...
2
votes
1answer
11k views

Importing CSV files into Excel using a macro

I want to develop a macro where in my Excel worksheet I type a date in a specific cell, and the macro will go into a folder containing text files. A database you could say. I want it to find the ...