• Excel file for big data analytics

    Can you please provide me with the Excel file sample for big data analytics with real world examples.

    khannamoney5 pointsBadges:
  • Business Objects 12.1 and Office 2010 compatibility

    How can I determine if BO 12.1.0 is compatible with Excel 2010?

    vballkitty5 pointsBadges:
  • Download data from iSeries to Excel

    How do I download data from iSeries to Excel?

    lr538615 pointsBadges:
  • Pull data from AS/400 table to Excel

    I need to pull data from a AS/400 table to Excel, and need to create a Micro for this. I am not aware of Excel Micros that much. Can I get some help?

    Aundhekar5 pointsBadges:
  • How do I get a macro to move between workbooks?

    I have a template (workbook #1) that I would like to copy data out of and paste into the workbook that I run the macro from (workbooks 2, 3, 4, 5...). The problem is that when I record the macro from workbook, excel codes the name of that workbook, making the macro unusable in workbooks 3, 4, 5.......

    Bondsmith5 pointsBadges:
  • DBF file formatting from excel to dBASE file in openoffice

    I am trying to save an excel file opened in openoffice as a dbf file. However when I try to "saveas dbf" a text box opens that says "this document may contain formatting or content that cannot be saved in the dBASE file format". I was wondering if anyone can help me with how it should be formatted...

    kimannep10 pointsBadges:
  • Export Arabic data from AS/400 to Excel

    How can I export Arabic data from AS/400 to Excel?

    YEMEN50 pointsBadges:
  • We are trying to make database of membership

    We're looking to create a database for our membership (particularly searching for an Excel sheet).

    jagdishchandrajoshi5 pointsBadges:
  • Establishing a connection from an IBM DB2 database

    I've been trying to establish a connection with an IBM DB2 database (from which I can extract data). Here are some of the details I have:Server NameData LibraryUsername/PasswordI've used both Microsoft Excel and SQL Server 2008 but neither way is working. Using Excel, this is what I tried: I have...

    ITKE1,052,165 pointsBadges:
  • Easy and faster way to pull data from a server using ODBC (VBA)

    I am looking for couple of options to pull data from AS/400-ODBC connection and manage data in Excel.

    xxsinghxx20 pointsBadges:
  • HTML, Excel, AS400

    can we post/store an excel file on the HTML site and link to the AS400 to pull data

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

    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 accompish this task without...

    Multipass5 pointsBadges:
  • convert report to excel without convater

    Is it possible to convert a 10g generated report to excel without excel convater?  

    MCAMCom15 pointsBadges:
  • Excel, Lotus Notes view

    Whenever I export data from view to Excel using the export menu, I choose in the format of comma separated values once exporting is done, I open it in excel with comma separated data as in separate columns, till this everything is fine. Now when I see data in a particular column in excel for eg...

    shivasanjay3,240 pointsBadges:
  • Current column name in Microsoft Excel

    Could someone tell me what the function is to get the current line number / current column name for cells in Microsoft Excel? Thanks!

    ITKE1,052,165 pointsBadges:
  • SAP ARC service line items export to Excel

    ARC (Annual Rate Contract) service line items with rate export to excel, so what is t-code?

    Pradeep3410 pointsBadges:
  • Excel to tsv

    How do I import excel to tsv format?

    lburks5 pointsBadges:
  • Upload Excel to SQL Server Table

    I have an Excel spreadsheet with 3 fields being used. (1) Material x(30) Key (2) Description x(30) (3) Extended Description (text) I want to create a table that I can match to an existing table where the key is the Material and update the description and extended description on the existing table....

    WorkAround5 pointsBadges:
  • Create Excel from AS/400 with multiple sheets

    I have a requirement to generate an excel from 2 different PF as 2 sheets in a single Excel file. I have created single sheet excel using CrtCsvDta command. Please help me to figure out to generate multi-sheet Excel from AS400.

    RamvishakRamesh2,505 pointsBadges:
  • Excel.exe process is getting struck in task manager and it’s not closing even the session is end

    Hi, My code is invoking Excel process to generate the report and that is killing once the process is completed. But sometime, couple of Excel.exe process is getting struck even the session is ended. Which is causing NFS memory full. Please advise me of what the the root cause to this issue is. By...

    FIRSTSCHOOL5 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.

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

Following