Instructions for importing a batch of DSM Data: Difference between revisions
| Line 41: | Line 41: | ||
* Open [[DSM_Labs_Consistency_check.accdb]] | * Open [[DSM_Labs_Consistency_check.accdb]] | ||
* Open [[query Import_request_matcher]] | * Open [[query Import_request_matcher]] | ||
* Go to design view and add the Import DtTm | |||
* On the SentDtTm column on criteria put the date you want to ran (Ex Between Mar 27, 2019 and May 13, 2019) | |||
* Go to Datasheet view and sort lowest to highest then filter to blanks only | |||
* Go to External Data then click excel | |||
* Go to X CCMDB DSM Lab imports Archive_raw then to the folder you want to save | |||
* Click Export data with formatting and layout then rename Ex. (No_Match_DSM_450.xlsx) then save. | |||
=== Cleanup === | === Cleanup === | ||