If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
SQL and VBA
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 . |
#3
|
|||
|
|||
SQL and VBA
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 . . |
Thread Tools | |
Display Modes | |
|
|