Updating excel data with dsn less connection vba

Rated 4.34/5 based on 894 customer reviews

We are going to focus strictly on linking to SQL Server tables for this exercise.

So the data thus becomes available to anyone with an Internet connection, but the application itself, the front-end (FE), remains on each user’s local computer.The process from this point forward is compatible with all releases of SQL Server since version 7.0.The first step in setting up a linked table is to navigate to the Linked Tables dialog in Access.This was in preparation for using Microsoft Access as a front-end tool for a SQL Server 2005 database.Though Access can be considered a sub-par application by the relational database elitists, it can be a very capable alternative for querying data from SQL Server without the learning curve associated with Visual Studio.

Leave a Reply