• 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:
  • 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:
  • Export Arabic data from AS/400 to Excel

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

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

    How to export data from AS/400 folder containing Arabic data in to Excel

    Jaipalsingh5 pointsBadges:
  • Correct password won’t open Excel doc in an attachment

    I have a password protected Excel document. I can open it with the password. When I send it as an attachment, I get a password is incorrect message.

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

    ITKE341,970 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:
  • 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!

    ITKE341,970 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:
  • How to export data from AS/400 in Excel

    Hi everyone, I would like to know how to in a step by step process export date from AS/400 iSeries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report...

    Itriconewbie5 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:
  • Zero keeps disappearing in my Excel spreadsheet column

    So I'm adding some of my personal information into an Excel 2007 workbook and I've noticed that when I put in a number count that starts with zero, it automatically disappears. Here's an example: 012345678 changes to 12345678 What do I have to do keep the zero as entered and not disappear.

    ITKE341,970 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:
  • Excel 2007 – how to add a average formula to that cell/s that ignoring 0%’s

    Okay I figured out how to ignore zero %'s for a graph. Now what I'm stuck on is how to add a average formula to that cell/s This is what I had: =IF(SUM(U171,U122,U74,U27)=0,#N/A,(SUM(U171,U122,U74,U27),(AVERAGE(U171,U122,U74,U27)) Thanks,Jared

    Jreifenstein001185 pointsBadges:
  • RUNSQLSTM and Excel

    Can an Excel spreadsheet be created with the runsqlstm?

    lewman5 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