• Excel file to ACT template

    Can an Excel file be saved as an .adt template to be used in ACT? Is there a different format that should be used for Excel? Thanks!

    kmatthews15 pointsBadges:
  • AS/400 to Excel data transfer – extra

    We are using Excel Com Add in on 2010 and 2013 and this is causing intermittent adding of a ZERO to some numeric data we are downloading from AS/400. We are not sure if this is an AS/400 issue (OS v6.1) and Client Access v5.8 upwards? Any ideas what might be causing this?

    TekViperMM80 pointsBadges:
  • Export Lotus Notes mail documents into Microsoft Excel

    Hi Team, we need to create an utility which export Lotus Notes email document (specially Body) into Microsoft Excel.

    agmayank10 pointsBadges:
  • Problems with refreshing Access data that has been imported to Excel

    Hi, I keep getting error :you attempted to open a database that is already opened exclusively by user "xxxx" on machine "xxx". When I look there is a duplicate database name with the .dlb extension. This lock seems to be on all day? at the end of the day my excel works perfectly(when the .dlb is...

    barbaraw5 pointsBadges:
  • How do I open two separate instances?

    How do I open two separate instances of Excel; using two monitors, how can you put different spreadsheets on each monitor?

    20650suewriter5 pointsBadges:
  • Microsoft Excel formula: Sum the column of times

    I want to know the excel formula to sum the column of times (in Hr:mm) format. for e.g. if times are 10.20, 10.10, 10.25 and 2.10 it should result as 33.05 i.e total no. of hrs and minutes.

    shivasanjay2,425 pointsBadges:
  • Downloading from AS/400 to Excel

    I have just being informed by a senior employee that it is wrong to download from AS/400 to Excel, that it gives the staff the opportunity to alter data. Please help with answers that I can use to table my case for either for or against. Reference please

    Ebejale5 pointsBadges:
  • How to open .db files with Excel

    Hi, how to config Excel to allow opening of .db files?

    cfs0105 pointsBadges:
  • Running display program using macro and input from spreadsheet

    Is there a way to create a macro (either from the iSeries or Excel) to copy/paste data from a spreadsheet into an iSeries screen and then invoke keystokes to perform an action within the interactive program?

    KevinCmyrgroup15 pointsBadges:
  • Change English numbers to Arabic numbers

    How I can change English numbers to Arabic numbers?

    Mark475 pointsBadges:
  • QSYSPRT

    Hi , A program generated two reports.There is a job that runs every monday , and these report are generated every week.They are copying the data in the report to a work file in Qtemp by the command CPYSPLF .Then they copy the records from work file to Qsysprt by CPYF. My queries are , is this...

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

    ITKE345,300 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:

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