• Access database table linked to Excel file question

    Can multiple instances of the same access database be open when linked to same excel file?

    SeenFresh25 pointsBadges:
  • DTS: Export to Excel

    I'm exporting a simple table to Excel but my problem is that the table columns will change every month since the column names will list month names (ex. May2009). Can I use ActiveX to dynamically create the transformation source? Please help!

    Stan100125 pointsBadges:
  • Converting Data in Excel to PF on DB2/400

    Hi All, I have data in the excel where each column equal to the field of a physical file. I want load this data into the PF on AS/400. Could any one let me know the process on how to do it. Thanks in advance

    rajsubhyd105 pointsBadges:
  • Do you have a favorite construction estimating software tool?

    What is your favorite construction estimating software tool? Are you using Microsoft Excel? What about Sage? HeavyBid? HardDollar? Something else entirely? What makes the software so appealing to you -- was there one feature that made you shout, "I need that now!" or was it the whole package that...

    Beastwood1,105 pointsBadges:
  • Convert Number value in text string

    I am using Microsoft Excel 2007. I want automatic conversion of a number value into relative text string. It means if I have "687" into one cell, then it should be converted into "Six hundred and eighty seven" into next cell. Please guide me for this.

    Makkes5 pointsBadges:
  • Excel question

    I have made some forms to use as proposals to sent to customers. I want to be able to send these as a document and not a spreadsheet. I need the formulas in the spreadsheet however to complete the proposal on my end. The pages print ok but I don't want to send an entire spreadsheet. Can this be...

    Alexworley5 pointsBadges:
  • How to paste data directly from Excel to PowerPoint graphic as data using Excel VBA

    I've been trying to search for ways to copy data from a spreadsheet onto the datasheet of a graph in an open spreadsheet. I am unfamiliar with VBA code, but got it to copy and paste to the correct slide, but only as text. I have been unable to select the actual existing graph and paste the data in....

    Charm20 pointsBadges:
  • Conditional formatting on Excel for Mac not showing

    I added a gradient fill to a column on my excel sheet but the color does not appear. It says the rule is applied but nothing is changed on the column or the table. What do I do to fix this?

    eperez35 pointsBadges:
  • How to convert a csv file into a xlsx one?

    Hi, I'm generating a csv file from an open hub in BW so I need to convert it into a xlsx one due to I need to upload it into the Microsoft SharePoint. Is there an abap function that does it? I know that there is one to convert an xls one into a csv. Thanks

    VPD5 pointsBadges:
  • How to recieve a excel file via AS2 running on iSeries

    I need to schedule to download reports from Walmat retail link. The reports are generated in excel format and downloaded using AS2 protocol. When I receive the file in iSeries it is not readable. I need to convert the excel format into data base file format. Any thoughts

    AS25 pointsBadges:
  • Excel to AS/400 PF

    I know this topic is widely discussed. But even after going through some of those discussion, I am not able to proceed. I have an Excel sheet which has one row header and one row of data, which includes both numeric as well as alpha data. I have opened it in notepad and but ',' separators after...

    RamvishakRamesh2,505 pointsBadges:
  • How to load an Excel spreadsheet to an Oracle database

    Does anyone know of a free tool that I can use to load an Excel spreadsheet into a Oracle database? I already tried Oracle SQL developer but it keeps giving me a NullPointerException. Can someone help me out there?

    ITKE366,225 pointsBadges:
  • coloring rows “if” true

    I have a profit & loss spreadsheet that I use to input expected expenses and then log the invoices when they are paid and I always highlight the row when I input the invoice number and invoice amount. Is there a way I can use conditional formatting or a function to automatically color the row if...

    Tstychalski5 pointsBadges:
  • Excel 2003: Novice user wants to set up database for research

    Using Excel 2003. I want to set up a database that can be added to by using a form format with drop down boxes, tick boxes and boxes to enter data. Don't know what it's called. can I do something like this to then use it to make queries for certain data?

    Hocosteo5 pointsBadges:
  • How to send a mail to multiple recipients from Microsoft Excel sheet?

    I have an excel sheet. This excel sheet has data for many recipients. every row has an email address (lotus/outlook) and then the next four cell in the same row has the data for the same recipient. I want a macro to be created so that when I run this macro a new mail is drafted for each recipient...

    Micqa5 pointsBadges:
  • Appending Excel to SharePoint list

    I am trying to create master database in SharePoint such that excel can be appended at the end of it. End result is to get dynamic reports / dashboards and email notifications from SharePoint. Please guide how this can be done.

    Navin88810 pointsBadges:
  • Import lotus notes view data from Excel

    I need to import frequently data from some Lotus Notes views into my Excel sheets, I want to know if they are a macro or a VB script which could do that.

    Witold200830 pointsBadges:
  • Data transfer from webpage to excel

    I have a complicated problem for data extract from a web site. It is about a horse race analysis. Problem description as below I want to retrieve some historical data and non-dynamic Datas are spread into many different web pages and they are in asp. Pull down menu is on the web page and have to...

    Hbongsui5 pointsBadges:
  • Microsoft Excel subtraction using VBA

    I would like to have some coding in vb related to subtraction in Excel sheet.I have 2 sheets.I need to take data from 2 cells from the first sheet and perform subtraction and then placeresult in sheet2.I have huge amount of data in sheet1.I need to perform this operation with all the cells in...

    Devisri20 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:

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