Most of our rolling stock is already in a basic Access database, can MRRM import data from another file?
Yes, MRRM can import data files in tab delimited format. MRRM includes extensive Input/Output capabilities including rolling stock, and other data element types. The program will output data in tab delimited format which can be read by spreadsheet programs such as Microsoft Excel as well as by database programs such as Access. If you enter a, say, rolling stock record or two in MRRM and then output them to a flat file using MRRM’s features and next read that file with Excel, you can quickly ascertain the sequence of the data elements. I recommend a spreadsheet program like Excel since the blank data elements are readily discoverable. I believe that you can output data from Access and import that data into Excel. Then it is a relatively simple matter of rearranging the columns into the MRRM required sequence to then input the data into MRRM.
