ERP - ODBC linking with MSSQL

Hi, there. Every ERPs have their own reporting tools. In here, I will show you on how to pull data out of MS SQL server and demonstrate it to user. Along the way, SQL command is a must in order to successfully exploit the query power.

1st off, you need to go control panel\ODBC and search for required version on the driver tab. If required version is not there, you then need to download appropriate MDAC- ODBC driver for MSSQL. Note: ODBC driver is not restricted to Microsoft but open to Oracle, DB2 ,Java and etc..

2ndly, Click on the System DSN, and then click "Add". There will be listing all the existing drivers. Just click  MSSQL server. From there, you may give a DSN name and point to your MSSQL server name. Next up will be authentication where you may either use windows login or SQL server login Eg, SA to gain the access right. After validated your login, you will be prompted to choose database from SQL server. So, just choose the one in which the data is being stored.

After you have successfully added the system DSN. Now, you may now open MS Access and do the data linking and import.