Solved

Spreadsheet macro

Posted on 2006-06-12
2
776 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 500 total points
ID: 16887115
0
 
LVL 12

Expert Comment

by:vb_jonas
ID: 16887131
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
advertisement module in core php 4 170
listing all functions in JavaScript 19 217
Windows Service to Receive TCP Packets 4 170
statistics basics sources 2 8
A short article about problems I had with the new location API and permissions in Marshmallow
If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …

829 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