September 6th, 2013, 11:56 AM
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
But how can I automate this and search 8000 rows in column A2 of a spreadsheet?
where SQLID like 'NTSR%'
AND upper(sqltext) like '%PS_AAP_ETHNIC_PMPT%';
What other tables other than PSSQLTEXTDEFN or PSPROJECTITEM can I use to search for values of NTSR?
September 6th, 2013, 01:52 PM
1) Open speadsheet -> Data -> Filter. Select "Custom" from column dropdown and enter your criteria.
Originally Posted by SFDonovan
2) Open (or import) your speadsheet with M$ Access and run your query.