(1) Start EnviroInsite and load the database. Take note of the reported warnings issued by EnviroInsite. You can click on the copy to clipboard and then past these warnings into MS Word or Excel. Make sure to resolve any noted inconsistencies between the well, screen, and observations tab. Problems that may come up are well ids that are not in the screens tab, or screens that are in the observations tab but not in the screen tab. Load the file again to make sure that the warnings do not come up again.
(2) Make sure that the column headers in each tab match the associated tables in MS Access. If there are additional fields in the Access tables then you should add these to the header row of EnviroInsite. There should be a one-to-one match of fields in the Access tables and columns in Excel.
(3) Open MS Access and load the EI database file. In some of the older files you’ll get an dialog box entitled EnviroInsite with shortcut buttons to view the data. If you get this then just close this down.
(4) Click on External Data and then click on the button that shows Excel with an arrow out of Excel into a table.
(5) Click on Browse and select the Excel file
(6) Click on the button at “Append a copy of the records to the table:” and select the Wells table from the dropdown control to the right of this button
(7) Click on OK (This should start a “wizard” within Access.)
(8) Select the Wells worksheet and click on the Next button
(9) (The next page should show your data with the “First Row Contains Column Headings” already checked.
(10) Click the Next button
(11) Click Finish
(12) Here’s where it can get ugly. If you did not resolve all of your reference problems in step 1 then not all of the data will be loaded. Sometimes it will put the unloaded rows into a special table, but not always. You may also get some other strange error messages like “subscript exceeded” or “operation failed”. These seem to be due to formatting codes in Excel that Access does not know how to interpret. What you can do to resolve this is to open a new Excel file and then copy and paste your data from the old file to the new file. Be sure to select “Paste Values” so you don’t get the funky formatting codes in your clean Excel file. Now try repeating steps 4 through 11 with the new Excel file.
(13) Once you have the Wells data you would normally also add records to the Constituents tab, but since you’ve already loaded the Constituents you don’t need to do so in this instance.
(14) Repeat steps 4 – 12 for the Screens tab
(15) Repeat steps 4 – 12 for the Observations tab
(16) Done !!! Buy yourself something. You deserve it.
