Posted to microsoft.public.excel.programming

David Wessell David Wessell is offline

external usenet poster

Posts: 10

How to iterate through results of SQL Query

Hi,

Easy question here, but I'm not finding any examples..

If I've just placed a SQL query, how can I iterate through the results
using VBA?

rs.Open "SELECT * FROM generic table", _
dbMain, adOpenKeyset, adLockPessimistic

---

THanks
David

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MS Query Results	Suzseb	Excel Programming	1	July 19th 06 11:16 PM
Query Results to UserForm	Noel	Excel Programming	1	September 29th 04 07:09 PM
Set a PivotCache as the results of a query	tod	Excel Programming	2	February 16th 04 05:41 PM
MS Query Limit results	Gunther[_2_]	Excel Programming	2	December 16th 03 08:21 PM
Query Results	Michael Burkett	Excel Programming	1	November 11th 03 07:46 PM

All times are GMT +1. The time now is 07:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us