Notes
-
Pay particular attention to the fourth screen shot: Getting the date formatting right for time stamp field when importing, so that MS Access accepts it as a date data type, is a little tricky the first time. You will also have to manully enter a pipe symbol ("|") as the field delimiter.
-
The Bib ID/MFHD ID/Item ID/Barcode fields do not need to be assigned a "number" data type, since you won't (or shouldn't) be performing any mathematical operations on them.
-
You're welcome to make up your own column (field) names, but the ones in the screen shots work. Access can be finicky about column names, and if it objects to a name you assign, it will error out each and every value for that column.
-
Once you have the data in an MS Access table, you can massage/sort/query that table by whatever criteria you desire. However, you will not be able to (accurately) sort by call number, since call numbers are not normalized.
|
