#1
  1. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2008
    Location
    Texas
    Posts
    354
    Rep Power
    7

    MS Excel as external table


    I need to do some analysis and research to find if any of these 8000 tables I have in a spreadheet that are going to be spit off into a separate database are used by any of our PeopleSoft processes.

    I'm assigned to Student Records identified by NTSR.

    So for table AAP_ETHNIC_PMPT, I could do something like

    Code:
    SELECT *
    FROM PSSQLTEXTDEFN
    where SQLID like 'NTSR%'
    AND upper(sqltext) like '%PS_AAP_ETHNIC_PMPT%';
    But how can I automate this and search 8000 rows in column A2 of a spreadsheet?

    What other tables other than PSSQLTEXTDEFN or PSPROJECTITEM can I use to search for values of NTSR?

    Thanks
  2. #2
  3. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    859
    Rep Power
    388

    Cool


    Originally Posted by SFDonovan
    I need to do some analysis and research to find if any of these 8000 tables I have in a spreadheet that are . . .
    . . . E t c . . .
    But how can I automate this and search 8000 rows in column A2 of a spreadsheet?
    1) Open speadsheet -> Data -> Filter. Select "Custom" from column dropdown and enter your criteria.

    2) Open (or import) your speadsheet with M$ Access and run your query.


IMN logo majestic logo threadwatch logo seochat tools logo