- You must do this first!!!
First run C:\Windows\SysWOW64\odbcad32.exe and under System DSN you will see entries for all of the university’s database servers.
Afterwards, go back to your already open Microsoft Access database.
There are two ways to go about this. You can import a whole table, or link to it. Both methods are available by selecting the ‘ODBC Database’ option as shown (located within the ‘Import & Link’ section, under the ‘External Data’ tab).
2. Make sure the radio button for ‘Import the source data into a new table in the current database’ is selected, then click the ‘OK’ button
Select the appropriate DSN from the list (‘Type’ is system), then click the ‘OK’ button.
You might be asked to log in, then do so as necessary and select the table you want to import, then click the ‘OK’ button
The linking method happens in exactly the same as the import method except that in the first step you select the radio button for ‘Link to the data source by creating a linked table’.