Improve company productivity with a Business Account.Sign Up

x
?
Solved

Spreadsheet macro

Posted on 2006-06-12
2
Medium Priority
?
810 Views
Last Modified: 2006-11-18
Hi
I have to write a spreadsheet marco that connects to a SQL database, and queries it and inputs the result into the spreadsheet cell.

Could anyone point me to some sample code that connects to a database using an ODBC source, and some sample code to query the database, that will go into a varible so that I can dumb it into a cell.

I am using Microsoft Excel 2003.

Thanxs for reading.

GrahamR99
0
Comment
Question by:GrahamR99
  • 2
2 Comments
 
LVL 12

Accepted Solution

by:
vb_jonas earned 1500 total points
ID: 16887115
0
 
LVL 12

Expert Comment

by:vb_jonas
ID: 16887131
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
No other job is as rewarding and demanding as building an iPhone app is. It is not really in the hands of the developer for the success of an iPhone app. Many factors operate jointly for every iOS application's success in the market.
Simple Linear Regression
Six Sigma Control Plans

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question