Solved

Spreadsheet macro

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

A short article about a problem I had getting the GPS LocationListener working.
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
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 …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

813 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now