********************************************************************************************** ********************************************************************************************** ** ** Sorting hash library files (HashKeeper, ILook, RDS) by a particular column ** with Microsoft(R) Office Access 2003 ** ********************************************************************************************** ********************************************************************************************** 1. Import file: - Click "File|Open", select file type "text files" and choose text file, press OK. (Only files with suffix ".txt" are allowed, so you may need to rename ".hsh" or ".ilk" to ".txt".) The Link Wizard appears. - choose "Delimited" , press NEXT - select "Comma" as Delimiter - check "First Row Contains Field Names" - select "none" as "Text Qualifier" - hit NEXT - field names remain the same, NEXT - choose a new table name, FINISH The new table is now listed in the "Database" window in front. 2. Sort table by column: - in the "Database" window, select the table by a single left-click - click "Queries" in the left frame - choose "Create query in Design view" (double-click) - select table, ADD and CLOSE - double-click on every column in the upcoming window in order to include all columns - after all columns are listed, go to the "Field" that you want to sort and click once in line "Sort" - choose "Ascending" from the selection list - run the query by selecting "Query|Run" in the main menu (or click exclamation mark icon) - save changes with "File|Save", specify a name for the query - close "Select Query" window 3. Export query results to text file: - select the new query by right-click in the "Database" window under "Queries" - choose "Export" in the upcoming context menu - select "text file" as file type and specify a file name for the sorted hash library The Export Text Wizard appears. - choose "Delimited" , press NEXT - select "Comma" as Delimiter - check "Include Field Names on First Row" - select "none" as "Text Qualifier" - hit NEXT - hit FINISH Do not forget to rename the sorted hash library file back to its initial format (".hsh" or ".ilk"). Erase the Access database files (suffix ".mdb").