December 20, 1999 11:54 AM

Solutions By Design: A Data Access Solution

Rating: (0)
SQL Server Magazine
InstantDoc ID #7843
Use existing assets for a cost-effective solution
Last month, in "Accessing SQL Server Data," I described the first three steps of a six-step process to distribute data views to the user's desktop, using Microsoft Excel as a low-cost front end to your SQL Server. Using the Pubs database as an example, I described how to set up the ODBC connection between Excel and SQL Server so that the views created on the SQL Server would be accessible from Excel. Now let's look at th...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Whew! Talk about concentrated! Hardly a chance to even pause for breath. Some tutorials are too simplistic, this one is too condensed - and devoid of diagrams or screenshots (often diagrams or flow-steps are better than screenshots). However, the idea behind it sounds really good, I don't know if I'll have the stamina (or patience) to work through it and make it work.
On a web-page, it is pretty easy to give explanations of terms such as SQL, for some people, this would be invaluable.
My employer will not buy in new software, presumably MSQ has to be purchased separately from Excel? Otherwise, the idea would be great. Everyone here loves Excel but regards Access with great suspicion, I am trying to persuade them that only something like Access can be used to manage the huge data we are putting together.

Geoffrey Alexander 5/5/2004 9:48:05 AM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS