• MICROSOFT INTERCHANGABILITY

    Does Word, Excel and Acess work together interchangeably?

    Swanson5 pointsBadges:
  • error solving

    "Provider=Microsoft.Jet.Oledb.4.0;Data Source="+path+";Extended Properties="Excel 8.0" " i write this ^ in source of click event of  button  i want to convert  the data in gridview that were in excel file but i got some error so please help me and take me out of this problem

    Amystudent25 pointsBadges:
  • Download from iSeries directly to an Excel xls file – no CSV

    I need a little help! Is there anything out there that I can incorporate into a CL program that will download a database file to Excel with an xls extension so no further converting is necessary. I tried the CVTPFXLS but get Pointer not set for location referenced.

    Sillyhp35 pointsBadges:
  • Read/Write Excel spreadsheet in Forms6i but no excel

    Hi!  I'd like to know if I there's a way to read/write a spreadsheet without to install Excel. I'm working en Forms 6i and I'm performing a programmed task, so a file csv doesnt' work for me, the application must access and generate the Excel file automatically.  Please, help me. Regards, thanks...

    PaolaChile35 pointsBadges:
  • Exceeding Limit in Excel

    I am loading 20k records from our AS/400 using Excel icon(transfer from AS/400) but after 16k records loaded I am getting message indicating that limit is over need to start in another worksheet. I changed file type under RECV - Details icon in AS/400 to Excel 5 then also no use same error. Pls Let...

    Alicsc370 pointsBadges:
  • Role of Excel/Access in SQL Server 2008 R2

    What is the role of Excel / Access in SQL Server 2008 R2?

    ITKE344,990 pointsBadges:
  • Data Transfer from AS400 to excel

    i need to download data from As400 to Excel using TTO option. How to download the description of the fields instead of field names. I have tried with the COLHDG & TEXT keywords in the DDS of the PF. But, the records are getting downloaded with the filed names only. Please revert to me ASAP if you...

    Saranyahere5 pointsBadges:
  • client access for Iseries export

    I have exported data via excel but I can't seem to get a certain column (data not numeric) across. I have displayed my database file and it is there but when I export it, that column is missing. What do I do?

    Informations30 pointsBadges:
  • Excel Pivot Table

    Sir I Using Excel Pivot Table I Create Calculated Filed Formula is If(((total Debit-total Credit)>0),(Total Debit-Total Credit),0) This Formula very perfect use But Pivot Table Grand Total show the zero (0) How Grand total sum run please tell me

    Sankar12345 pointsBadges:
  • Office 2007 labels using an Excel worksheet

    What to do when I cannot get Excel spreadsheet to link with WORD document to make mailing labels

    Kappy5 pointsBadges:
  • Exporting data from SSIS to Excel

    I am trying to export data into Excel from SSIS. For the purpose of this question, the table is called “products” and has two columns. I would like to extract each row of data into a separate Excel file and save it with the product name so I can email it accordingly. How do I go about this?

    WindowsServerATE335 pointsBadges:
  • Export from Visual Basic 6 to Microsoft Excel file

    how to export visual basic6 to excel file

    Goood5 pointsBadges:
  • Change date format

    I have a date field stored in the i5 as yymmdd that I would like to change to mmddyy when exported to Excel. If I just re-format the cell, Excel treats the number as a Julian date and mis-corrects the date. The other issue is that Excel drops the leading 0 so everything in this decade is...

    DanBubis75 pointsBadges:
  • What formula is needed for this below in Excel?

    What Excel Formula's could i use? First # is starts with 1  back slash 2400.   2400 stays the same only first # changes. example below: [table style="border-collapse: collapse; width: 65pt;" border="0" cellpadding="0" cellspacing="0" width="86"> [col style="width: 65pt;" width="86">[/cOLIST]...

    Jreifenstein001185 pointsBadges:
  • The “TRUNC” Function in Excel

    I used the "trunc" function this way "=TRUNC((H41-(I41*25))/10,9)", where H41is "=(A41-INT(A41))*100" and I41 is "=TRUNC(H41/25)".  A41 is 346.95. With the Excel 2003 version on my computer, the result is 1.999999999; when, in fact, the result should be 2. What am I doing wrong?  Or is there a...

    Whabby90 pointsBadges:
  • excel encryption

    I wish to encrypt and send excel spreadsheets to customers where they can modify some input data and calculate but not read formulars or change the spreadsheet. I want a form of security that is better that the standard microsoft encryption that cannot easily be broken by password crackers.

    Mosswood5 pointsBadges:
  • Should we use Web services to develop this integrated application?

    We are developing an integrated application that will incorporate excel application, access databases and pda applications using visual basic 2005. Problem is whether to use web services to develop the project. This request for help was originally submitted to the Research Assistant on WhatIs.com.

    ResearchAssistant855 pointsBadges:
  • Automatically Transfering from Excel to iSeries

    I see there is a Transfer Data to iSeries option but is there a way of making this run automatically daily? Can something be schedulled from iSeries to initiate that? I want to reduce user intervention so would prefer not forcing the user to daily execute the upload. Any suggestions? Thanks, Rod

    RodVerity20 pointsBadges:
  • Excel 2007 Large file issues

    I use Excel 2007 to do a fairly large multidepartmental Financial forecast and results package. The file size is currently at 48,000 KB and will continue to grow. I have this file open along with others of its size at the same time during use. Frequently Excel will crash during an autosave, when...

    Excelguy5 pointsBadges:
  • iSeries to excel Order of PF changes

    when I use a DTF to download directly to excel the order of my data changes. The PF is NOT keyed and I am NOT selecting any order on the DTF. It is intermitten. any suggestions?

    AmandaC30 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