• Creating and importing data into a relational database

    I just started programming six months ago. I have a project to import data into a relational database. I have data in an Excel file that I need to import into a database. The application is recruiting software, for government jobs. I have a list of applicants and the jobs they applied for. First, I...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Copy past in excel using VB

    i want to cut data in a colunm H and copy it in column B. i tried to record macro and run it. but i am not getting the values in column B. i am using excel macro and vb code to do this. i understand that the data in colum is cut and the data is not retrived while it paste in column B. Can Any one...

    Krishsrikanth5 pointsBadges:
  • Select documents from a Notes View and paste into Excel

    I'm looking for code to select documents from a particular View and then paste it in a particular template of a Microsoft Excel spreadsheet. Is this possible? And if so, can anyone offer me some sample code?

    Domino Ask The Experts435 pointsBadges:
  • How do I export an Outlook 2007 public folder calendar to Excel?

    With Outlook 2007, I want to export from a calendar in a Public Folder into an Excel format. The Import/Export menu option only allows me to pick as a source for the export, a calendar in my personal folders. How do I export from a Public Folder calendar? This question was submitted by a...

    BrentSheets6,925 pointsBadges:
  • Whats a good tool/software to import (excel, csv) into IBM DB2

    Whats a good tool/software to import (excel, csv) into IBM DB2? Would be great if this tool/software is free or doesn't costs to much. thanks

    Geyes15 pointsBadges:
  • Microsoft Access and Oracle

    Can tables created in Access or Excel be imported into Oracle?

    Micheline foxxe10 pointsBadges:
  • ,temporary files, on win02/03 servers in access(.ldb files) and excel are not deleting when applications are closed

    can someone provide a possible solution

    Wildbull5 pointsBadges:
  • Changing Color in a Cell

    I am updating a spreadsheet each month which is automated. I have written a macro to update this spread. Each month I append four columns to the end of the spread sheet and update the data in the spreadsheet. The problem that I am having is trying to figure out how to update the heading color for...

    Kioh4650 pointsBadges:
  • Exporting large files in Reporting Services 2005

    Reporting Services 2003 uses a lot of memory for the Excel Export, making it impossible for files 15 MB or larger. Is this still an issue in Reporting Services 2005 or above?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Update excel charts auto from as400 data

    I have a user request to create charts in excel using data held on the as400. I can do this in seperate steps but the user wants it as automatic as possible. At the moment : I run a query on the as400 to create data file I transfer using client access I open in excel & then copy data to graph excel...

    Gerrib150 pointsBadges:
  • handling text overflow

    Text that is too long for a cell can be handled in several different ways. What is the difference between: (1) Not giving Excel any instructions about what to do with the text overflow (2) Letting Excel wrap text in a cell (3) Using ALT+ENTER to cause Excel to go to a new line while entering text....

    Brad3386015 pointsBadges:
  • Automated file transfer from AS400 to Word?

    A search400.com reader wrote in with this question: I need to take a spool file (say a Collection Letter) generated from RPGIV. I can copy this spool file to a physical file if needed. I want to automatically import or send this file to Microsoft Word for editing purposes. I have used the 'ADD-INs'...

    AS400 - Ask the Expert485 pointsBadges:
  • Editing exhisting macro

    I have an exhisting macro but now I want to delete column's E and H in one of the sheets and am unsure how to edit the macro to correspond to this change.

    Cadenthais15 pointsBadges:
  • Referencing clip art in Excel

    Is there a way that I can reference clip art in Excel? For example, based on the type of car selected from a Data Validation list, I want to show that type of vehicle from a clip art image.

    Rbeyer15 pointsBadges:
  • Charts from internal references of external data

    I can access and process the external data from another worksheet just fine (I'm grabbing data from one excel spreadsheet to plot on another), but I need to process this data before plotting (I need to normalize the data to the max value in that column and the number of rows in each column...

    Nanopit5 pointsBadges:
  • Writing excel RTD to a file

    I have an excel spreadsheet set up using the RTD function to update a row of values every 2 seconds. How can I get excel to append a csv or xls file with the RTD values every time they change? Alternately, can some code make the RTD row be copied and pasted to a new row so that all of the incoming...

    Rtd guy10 pointsBadges:
  • easy way to automate uploading data from a word document to a spreadsheet?

    I have a spreadsheet to verify datafields for. This needs to test for example state all the valid entries. I do not want to save off a spreadsheet form of the template i am testing one for each data value I need to test. Is there an easy way to create many spreadsheets off of a data file I create...

    Juls45 pointsBadges:
  • Cell Colors in Excel

    I would like to have some code that will update the color of a cell based upon values in other cells. Even when the cells are on different worksheets within the same workbook.

    TweetyBird695 pointsBadges:
  • Extra columns on export to EXCEL

    How do I avoid the extra columns upon Crystal export to EXCEL?

    Bozotheclown10 pointsBadges:
  • User permissions in MS Excel

    I have a question on sharing an MS Excel file. Is it possible to restrict a file so that each user can modify only his own tab within that file? Also, is it possible to, under the same of restrictions, have a group of admin users who can modify all the tabs?

    Windows Security ATE160 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