Importing is potentially complicated since it requires that the table to be imported has the correct format. Before importing user data it is recommended that you first create a new user and then export the data using . This will give you a file which you can use as a template to ensure you have the right field names. By looking at the record for the new user you can see which fields are mandatory (mandatory fields will be non-null, null meaning empty). Fields which are null need not be present when you import. The exception to these rules is the UserID field. When importing into a traditional file-based database it is recommended that you do not include this field. However, when importing into an ODBC multi-session Access Manager database this field must contain a 32 bit integer which is unique for every user. With a new database this can simply be an incrementing value, but with an old database it may prove problematic ensuring the imported users have an ID which will be unique in the Access Manager database.
Before importing it is highly recommended that you back up the Access Manager database because if the imported data is faulty it may render the database unusable. If the import engine finds that the import file is incompatible it will reject the entire content, but you should not rely on it finding every potential problem.
Once you are ready to import select from the menu. Note that some file formats contain a table or sheet. If the table or sheet name is not Users the import window allows you to type in a different name.
To export user data you can select from the menu. You can also select whatever data you want in a list pane and select from the menu to copy the data in tab separated variable form to the Windows clipboard. The data can then be pasted into any application that will accept it, such as a spreadsheet.