Importing "report format" xls spreadsheet

  • I'm looking for some specific documentation from Microsoft that will ease my troubled mind. I have to be able to ensure, with 100% reliability, that the spreadsheet I'm bringing in will not change at all during the import to a Raw table.

    The data comes from a public entity and is basically a report. First 4 rows are garbage, no problem, I can kill those. The next row hows columns 1 through 9. The problem is that Colume 3 and 4 are on top of each other. Column 3 is a unique identifier for that group of data, and column 4, which is the very next row, is the date (also very important).

    There is usually a blank space between the various groups of data, so I can handle that as well; however, if the data is shifted in anyway, it's corrupted and I lose the relationships I need.

    Names State Id/Date Gender

    Sylvester Tx 2 M

    Tweety Tx 5/21/1969 ?

    Daffy Tx M

    Speedy Tx M

    Donald CA 3 M

    Daisy CA 4/15/2015 F

    Rosy CA F

    ETC., ETC.

    If this doesn't make sense, I'll do some more 'splanin... I'm researching a script task to open the spreadsheet, and move the ID and Dates to their own columns and copy them for every element in that row., but If I have assurances that the file won' change on the way in, I can do it in the Raw table.

    Thanks in advance.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply