• BOM Download To Excel For I&PD Exercise

    Are there easy directions for me to download from the SAP BOM's comprising 7000 lines to Excel for manipulation and pivoting of the data?

    NDIRISH5 pointsBadges:
  • How do I limit the number of selected check boxes in a list to only having one check box selected in an Excel spreadsheet?

    I am recreating a transfer form we currently have on paper into an Excel spreadsheet to have it electronically emailed. In the form I have a section that asks the user to choose a desired station to transfer to from a list of 3 stations with check boxes next to each station. I would like to have...

    2knowmore5 pointsBadges:
  • 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

    JohnsonMumbai1,160 pointsBadges:
  • 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

    Bertski40 pointsBadges:
  • 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...

    Ringside35 pointsBadges:
  • import from excel to oracle 9i

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

    Binty25 pointsBadges:
  • 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

    IONVa5 pointsBadges:
  • 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...

    Jjvaldez5 pointsBadges:
  • 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...

    McNitro255 pointsBadges:
  • 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?

    STARter20095 pointsBadges:
  • 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

    NatpudanMoorthy5 pointsBadges:
  • Excel to Access conversion

    Accounting came and asked me if a very complicated Excel spreadsheet that they are using for cash receipts could be "moved" into Access. I explained to them the difference between a spreadsheet and a database and that Access could definitely be used to better handle transactions etc. but it would...

    KSoniat610 pointsBadges:
  • 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...

    Hunter115 pointsBadges:
  • 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...

    845915 pointsBadges:
  • 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...

    aceofdelts1,850 pointsBadges:
  • 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...

    Brianaaskew40 pointsBadges:
  • 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 to...

    Cunninjoe320 pointsBadges:
  • 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

    Wanthelp10 pointsBadges:
  • Create a file with formulas on the iSeries and send to Excel.

    I can create a file in SQL that has formulas in it (i.e. '=A1*B1') and I can send them to my PC and open them in Excel. However, the formulas are showing instead of the results. If I click inside the cell and hit Enter, I get the value instead of the formula. BUT, I want this automated and don't...

    JeffWilson20 pointsBadges:
  • How do I overcome the “Could not find installable ISAM. Excel 2007″ Error? Ex

    I got the "Could Not find installable ISAM error" while uploading an Excel file in my application.This seems to be happening at the "connection.Open()" code line. -- Web Application -- .Net 2.0 -- Testing using IIS 7.0 on Vista Ultimate -- Office 2007 Enterprise Installed on machine. Code works...

    Donnybrasco10 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following