Solved

Spreadsheet macro

Posted on 2006-06-12
2
779 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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
This article will show, step by step, how to integrate R code into a R Sweave document

735 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