SQL and VBA

I come from a DB2 SQL background. Using Access is new to me.
In VBA using SQL how do you grab multiple records into a
table????? i.e...define a cursor and fetch, as in DB2??
Have looked in many books but cannot figure out.
Any info leading me in right direction appreciated.

Thanks

You need to use ADO or DAO to open a recordset to grab the
data. Then you can use the cursor to scroll through the
recordset in code. Look for either ADO or DAO under MSDN,
or better yet, pick up a Access book, or even VB book.

Access Developer's Handbook is probably the best.


Chris Nebinger


-----Original Message-----
I come from a DB2 SQL background. Using Access is new to
me.
In VBA using SQL how do you grab multiple records into a
table????? i.e...define a cursor and fetch, as in DB2??
Have looked in many books but cannot figure out.
Any info leading me in right direction appreciated.

Thanks
.

ok...thanks... actually have 3 access programming books,
but still could not figure it out...
Now I know what to read up on..


-----Original Message-----
You need to use ADO or DAO to open a recordset to grab the
data. Then you can use the cursor to scroll through the
recordset in code. Look for either ADO or DAO under MSDN,
or better yet, pick up a Access book, or even VB book.

Access Developer's Handbook is probably the best.


Chris Nebinger


-----Original Message-----
I come from a DB2 SQL background. Using Access is new to
me.
In VBA using SQL how do you grab multiple records into a
table????? i.e...define a cursor and fetch, as in DB2??
Have looked in many books but cannot figure out.
Any info leading me in right direction appreciated.

Thanks
.

.