• How do I sort an entire state customer list by only the zips I work with?

    how do I sort an entire state customer list by only the zips I work with

    Mayabel025 pointsBadges:
  • uploading an excel spreadsheet to the as/400

    I've seen a developer with an Excel spreadsheet on the iseries server, how do I upload an Excel spreadsheet to the iseries and populate it with data so I can then download the finished product to my PC?

    Chuck3105 pointsBadges:
  • Visual FoxPro 6.0 troubles exporting large files to excel

    I have large databases that need to be sent to customers in a manifest.  So i export it from FoxPro six to excel 5.0 and save it in my documents then attach it to an e-mail. The trouble i am having is exporting a large database.  FoxPro does not export the whole thing when i export it. It stops...

    0 pointsBadges:
  • Exporting large files from FoxPro 6.0 to excel

    I asked about exporting large files from fox pro 6.0 to excel because my computer was cutting off large data base i am trying to export. This is the answer you gave me: Excel is stopping at 16k records.  As a workaround, export to CSV format; you can then use a text editor (e.g., Wordpad) to split...

    0 pointsBadges:
  • create a login screen in VB.net

    I am wanting to create a login screen that will verfiy the login number to either a text file or an excel file. I have no idea what to do.

    Mrwes5 pointsBadges:
  • Workbook sheets

    How do you send a copy of only the sheet vs. the entire workbook to someone?

    Jrhoads5 pointsBadges:
  • Trying to run remote command to view AS/400 UNC and failing!

    I need some ideas here...I'm stuck. I'm running an RPG program that builds some CSV files for our accounting department. Because they love Excel, I had to make it so that the program breaks the data up into separate CSV files so as not to exceed 65,535 rows. Anyway, I am saving the stream files...

    Koohiisan5,020 pointsBadges:
  • How to export excel data to Sql server 2005

    How to export excel data to Sql server 2005

    Rasheed1802075 pointsBadges:
  • Exporting to Excel – Sort doesn’t work due to merged cells

    How can I change my SSRS to allow exporting into EXCEL and eliminate the header portion of report which includes merged cells. These prohibit my user from being able to sort a column in the table data.

    Gma885 pointsBadges:
  • Any tools for comparing office docs /whole directories? But ignore dates, page nums, etc.

    I am a developer/tester and want to regression test some crystal reports that are generated as excel and rich text.  The reports have the date run in the header so I want to exclude that.  Any suggestions?

    Janeway25 pointsBadges:
  • Multiple Names in Excel 2007

    I have a Excel sheet with hundreds of names and the same person may be repeated twice How do I create a formula so that I can like it to a new sheet and it only show a persons name one time

    Maine325 pointsBadges:
  • Problem in Data Downlod from SAP to Msoffice 2007

    Problem in Data Downlod from SAP to Msoffice 2007. If i use data export option from SAP to Excel 2007 a blank xls sheet open but no SAP data apear in sheet.

    Mkamil5 pointsBadges:
  • AS/400 file to Excel with Headers and Footers

    I need to attach an Excel s/sheet to an email. I currently do that via the CPYTOIMPF as a CSV file but this doesnt give give me the true Excel Header row, which is a requirement. Is there any easy way to do this?

    NJFred35 pointsBadges:
  • I need vba code to update item cost from a word document w/o changing the previous wks item cost in Excel 2004

    I have a work book with week 1 - 5  ending inventory worksheets.  I need vba code to update item cost from a word document w/o changing the previous wks item cost.

    J1549120 pointsBadges:
  • Outlook 2007 excel attachments

    I was sending an email with an excel doc. right before i hit send, I opened the attachment, realized I needed to make some changes. Started on the changes, in the middle of that, I removed the attachment from my email message. I continued working on the still open spreadsheet and saved it multiple...

    BOBE5 pointsBadges:
  • Copying from Excel using clipboard in a gridview

    Hello, i am working with vs2008 (web application) and I want to copy some content from an excel sheet and and using the clipboard i want to copy the contents in a gridview I have tried using Clipboard.GetDataObject() but no matter what ever i do it is always returning null so can anyone suggest me...

    Vamsikrishna2015 pointsBadges:
  • Macro code for QC to Excel?

    I need a macro code to pull result table from Quality Center9.2 to excel sheet....Can someone help?

    Viv0rns5 pointsBadges:
  • Moving .XLS from a folder on an as400 to a shared folder on a network

    I have an excell spread sheet generated from Sequel, I can get it ot a folder on the 400 but would like it get it to a shared folder on my network. I have tried to copy it FTP it and nothing seems to work.

    Johnd0155 pointsBadges:
  • minor loss of fidelity but cant find data!

    I have a large database saved in xls. 2003; I changed one column heading and got a message that reads: Compatibility Report for Thurs Brkfst Data Base.xls Run on 11/20/2008 16:50 The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or...

    mmpp295 pointsBadges:
  • Count Distribution

    From an input table consisting of YEAR and COUNT, e.g. YEAR COUNT 1999 3 2000 4 2000 7 2000 15 Can a Pivot Table or SQL Query be constructed to output a Yearly Count Distribution? e.g. YEAR 1->9 10->19 20->29 1999   1 2000   2        1 Thanks, JaG

    Jaggerdude60 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