Performance files to Excel
I know how to run performace tools on Iseries but how can I download the Iseries performance files into Excel and create a graph on the data? Thanks

Answer Question   |  January 5, 2011  4:16 PM
excel, Excel Database, IBM 9406, iSeries performance, Performance management

generating a custom database from an existing database
from a excel database with say 300 names, I would like to click a button to choose the names and quantities to generate a custom vdp database.

Answer Question   |  December 21, 2010  12:17 AM
Database Management Systems, Excel Database

Using Excel 2010 to pull data from SQL Server?
How can I use excel 2010 to pull data from my sql server? I have an odbc connection set up and need data from a specific table in a specific database. I want excel to do some projections and calculations.

Answer Question   |  November 1, 2010  9:05 PM
Excel 2010, Excel Database, ODBC, SQL Server, SQL Server database

Is there a standard formula for counting highlighted cells in Excel 2007?
Is there a formula for when you highlight some data cells, for use of simply counting rows, that Excel will give you the count of those cells as the answer on another sheet in the workbook- just by highlighting? But this is based on highlighting random cells in a column every day, never the same [...]

Answer Question   |  June 6, 2012  3:20 AM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel Database, Excel functions

Data transfer from Access 2007 to Excel 2007 stops at 65,xxx rows
How do we transfer/export data with over 575,000 rows in Microsoft Access 2007 to Microsoft Excel 2007? Is there a way to change the export data # of rows restriction of 65,xxx rows to 1 million rows in Microsoft Access 2007?

Answer Question   |  February 17, 2011  5:19 PM
Access 2007, Data transfer, Data Transfer Function, Excel 2007, Excel Database

Matching data in Excel
Hi, We have two sets of data in Excel that we need to match up and combine when they match. Spreadsheet 1 has two columns, A is a S/N and B is the page count. Spreadsheet 2 also has two columns, A is the S/N and column B is an ID number. We need to [...]

Answer Question   |  September 28, 2010  8:15 PM
Excel 2007, Excel 2007 functions, Excel Database, Excel worksheets

Excel date format
I am trying to copy data from one of our systems into Excel. Everything copies into Excel except the dates. My source data date format is MMM DD, YYYY (example Jul 14, 2004). I have tried changing the Excel from general to text and also tried changing the date formats.

Answer Question   |  September 22, 2010  1:15 PM
Database migration, Excel 2003, Excel 2003 functions, Excel Database

Retrieving missing Excel data
I had an excel file with 10 worksheets on it. I opened the file yesterday and found the whole 10 worksheets missing from the file. What could have caused it and is there a way to retrieve this data back to the file?

Answer Question   |  June 26, 2012  11:17 PM
Backup & recovery, excel, Excel Database, Excel error messages, Excel worksheets

Exporting large files from FoxPro 6.0 to excel
I asked about exporting large files from fox pro 6.0 to excel because my computer was cutting off large data base i am trying to export. This is the answer you gave me: Excel is stopping at 16k records.  As a workaround, export to CSV format; you can then use a text editor (e.g., Wordpad) [...]

Answer Question   |  August 17, 2010  6:17 PM
excel, Excel Database, Excel import/export, FoxPro, FoxPro 6

Importing large sets of Excel 2000 data to SQL database
I have large data sets of over 5 million customers in several excel 2000 worksheets. I would like to import the data to a SQL database and preserve all data including notes fields which are huge and contain all types of characters. What is the best method of achieving this?

Answer Question   |  August 18, 2010  8:08 PM
Data migration, Excel 2000, Excel Database, Excel worksheets, SQL Database, SQL migration

Excel as a front end to sql, data integrity
how do I put a value in a sql field that will not be counted in a excel pivot table? I am using excel as a front-end to sql. In particular, I am using pivot tables to slice and dice sql tables. The field I am interested in has either a text value or a [...]

Answer Question   |  July 27, 2010  6:00 PM
Excel Database, SQL 2005, SQL Export to Excel, SQL Server, SQL to Excel Database Conversion

Crystal Reports 11 problem with excel spreadsheet
I AM USING AN EXCEL SPREADSHEET AS MY DATABASE. ON THE SPREADSHEET I HAVE A COLUMN THAT HAS NUMERIC AND ALPHA VALUES. WHEN A ADD THIS TO THE CRYSTAL REPORT ONLY THE NUMERIC VALUES DISPLAY AND THE FIELD CANOT BE FORMATTED AS ANYTHING OTHER THEN A NUMBER FIELD. ON THE EXCEL SPREADSHEET THE COLUMN IS [...]

Answer Question   |  July 9, 2010  4:14 PM
Crystal Reports 11, Excel 2000, Excel Compatibility, Excel Database, Excel Formatting

Automatically populate a form based on a match from another worksheet.
Ok, here goes… I have a very large talent management database that is housed in Excel. This database includes information on performance ratings, work history, education, etc. on every employee in the company. I also have a ‘Talent Profile’ form (also created in Excel) that I give to HR whenever they need to review an [...]

Answer Question   |  February 25, 2009  6:18 PM
Excel Database, Excel Forms, Microsoft Excel