Updating excel data with dsn less connection vba

In truth, you have many options for setting up Linked Tables from Access; many RDBMSs (Relational Database Management Systems) and Microsoft Office applications for example - even Share Point and Outlook are options for linking tables back to Microsoft Access.

For the purpose of this tip however, we're going to focus exclusively on Microsoft SQL Server.

The table linking will still complete successfully whether you set a Primary Key or not.

Once you have made your way through the previous step you will see a table listing similar to what is below.

Select the appropriate security measures to authenticate to the data source referenced in the DSN and click the 'OK' button.

If you have rights to the database associated with the DSN you will be presented with a listing of database objects (note that you are not limited to linking just to tables, but rather views and stored procedures are available options also).

I was banging my head trying to get a simple ODBC connection functional and couldn’t locate instructions that actually worked anywhere.

Since we are focusing on SQL Server as a data source, navigate down the list of 'Files of Type' options and select the 'ODBC Databases()' option.

Then click the 'Lin Once you have either created or identified the proper SQL Server DSN, highlight it and click the 'OK' button.

From the menu bar, select inked Tables as shown below: By default, Microsoft Access will want to link to another Access database for it's Linked Table source.

Browsing the 'Files of Type' pull-down menu on the bottom left of the interface will give you a general idea of just how broad of a scope is available for Linked Table sources.

Leave a Reply