Microsoft Excel

Is it possible to restrict running of NASTIE (Now a simple tool in Excel) on system i

Is it possible to restrict running of NASTIE (Now a simple tool in Excel) on system i

How to export excel data to Sql server 2005

How to export excel data to Sql server 2005 Software/Hardware used: Sql server2005 and Ms excel 2007

Converting SQL 7 Database to Excel

Hi, I would like to know any possible way of converting my Sql 7 Database to Excel formats. Any ideas anyone. Thanks

Data transfer from AS400 to Excel 2007 Stops at 16,xxx rows

I am using client server to access my AS400.  i downloaded and installed it within the last 6 months i have the excel add on installed and it seems to be working well on tables with less than 16,xxx rows.  1. can anyone help me find out if there is a more up to date add on for excel 2007? 2. My...

SQL 2008 Security: How do I give users access to just views within a DB?

[h1 class="subject"] [/h1] I have inherited a SQL DB and need to give a group of users access to some views within a DB. We do not want them to access the tables, just the views. They will be connecting using MS Excel for reporting purposes. Do I use a role or schema? What is the best practice to...

Download Spool file to Excel Format

Hi Guys, Do you have any idea how to download the Spool Files(WRKSPLF with PRTF) to Microsoft Excel?   Thanks Mickey

Import GPO XML report to Excel

I am trying to find a way to Import GPO XML reports into Excel for comparison. I am unable to figure an easy way to convert the files to rows and columns

Sharing Problems in Excel

We have several spreadsheets that we share with 5 users. Some of these worksheets seem to grow to a large size in a short amount of time, even though they actually don't contain that much information. These are files that several people are updating and viewing many times per day. For example, I...

Outlook 2003: Export PST Emails To Excel

When I use the "File > Import & Export" command from Outlook 2003, I have mixed results. I keep my emails in sub-folders off one of several PST files that I use regularly, in the "All Mail Folders" side-panel. I broke up the larger folders into smaller ones in case there was a size limitation....

Arabic Text In AS/400 to Excel

Arabic Text when transfered to from AS400 to Excel displays garbage. Is there an add in I need to install?

Working with Login Userforms

I've been doing research on Login Userforms and have come up with a code variation similar to coding trend. However, I am having an issue clearing the previous information, allowing the user to reenter their password before the loop continues. (i.e. the user inputs "password", receives an invalid...

How can I import data to mainframe from Excel in REXX

I have the excel sheet with few fields, I want to import the excel data from my desktop to a mainframe dataset

OFFICE XP ERROR MESSAGE

Dear friends I have one system that should member of Domain I am all ready installed the Office 2003 applacition in Domain But after installing the applation whin i oppen the file I am getting erroe message Microsoft excel has not been installed for the current user plz run setup to install the...

Data transfer .XLS to iSeries

It's worked the last 4 tries (tho had to tweak each time), but now I just get basically one long field coming in. The comma delimitors are treated as just another character byte. While setting up a "power user" to take over this function (so no .fdf or other residuals from prior successful...

SAP export to Excel 2007

when exporting a spreadsheet to excel 2007, currencies show in the wrong format (ie. 1,882,456.96 shows as 1882456:96). I've tried to format the cell but this does nothing. Also I've verified switching the regional settings but no luck there neither. Help will be trully appreciatted, Max.

Paste records in OLE Unbound Excel Object in Access Form

Ok so I have built a database that is used to house and manipulate records that I get from a monthly report that is posted online. Basically I work for the Army and we have over 50 units. Each unit has anywhere from 10 to 1000 soldiers in it. I initially had tried to build a database with a table...

UPK scripts/Excel Scripts and HP Quality Center

How time consuming is it to convert UPK Scripts into HP Quality Center and set them up for automated testing? What about test scripts in excel

Creating a .xls text field from AS400 file with dd/mm/yy field

I am using client access to create a spreadsheet from an AS400 file. Although a date field is defined as alpha in AS400 DDS specs, the field is populated as dd/mm/yy in the AS400 file. When the spreadsheet is created using client access, the field does not come across as text. I need the field...

import from excel to oracle 9i

how can i import data from excel to oracle 9i?

Vlookup Worksheet Function

I develop and maintain pricing models that involve a lot of looping through cells and applying assumptions. For some reason I never seem to be able to get the vlookup worksheet function to work when looping through cells. It either says 'application-defined or object-defined error' or more...