Government supplied data may either come as a data "dump" (ie csv, text, or other files), or already compiled into an Access database.
In the former case (data delivered as files) the user has the option to:
1. Use the Auto-Import functionality, if available for that format.
2. Copy the data from the files to a new Access database, retaining the data table structure (columns). See Using your own database through ESdat for more information on how you can customise ESdat to your needs with this data and the factors to consider. This approach has an advantage over option 3 in that the data can be retained and analysed in the original structure.
3.Import the data into ESdat using the standard "Hydrogeology and Environmental" database structure. It will be necessary for users to match the supplied data against the correct tables and columns in ESdat. In some cases users may wish to customise the database to add additional tables or columns.
In the latter case (data delivered as an Access database), the user has the option to:
1. Open the files directly in ESdat. See Using your own database through ESdat for more information on how you can customise ESdat to your needs with this data and the factors to consider. This approach has an advantage over option 2 in that the data can be retained and analysed in the original structure.
2. Migrate the data into the standard "Hydrogeology and Environmental" database structure. It will be necessary for users to match the supplied data against the correct tables and columns in ESdat. In some cases users may wish to customise the database to add additional tables or columns.