Visual Basic&database, Join two recordsets into one using DAO 3.6?

Join two recordsets into one using DAO 3.6?

Author	Message
cjya #1 / 5	Join two recordsets into one using DAO 3.6? Hi, I am using DAO 3.6 with Access Database in VB6. I would like to know if there is anyway to join two recordsets into a new recordset or merge one recordset into another. Thanks in advance for any help. ----------------------------------------------------------- Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free! http://www.--*.com/
Wed, 29 Jan 2003 03:00:00 GMT

Robb #2 / 5	Join two recordsets into one using DAO 3.6? Hi. Can you simply use the logical OR in an SQL query, eg: Select * From MyTable Where MyField = OneThing Or MyField = Another Quote: >Hi, >I am using DAO 3.6 with Access Database in VB6. I would like to >know if there is anyway to join two recordsets into a new >recordset or merge one recordset into another. >Thanks in advance for any help. >----------------------------------------------------------- >Got questions? Get answers over the phone at Keen.com. >Up to 100 minutes free! >http://www.keen.com
Thu, 30 Jan 2003 03:00:00 GMT

cjya #3 / 5	Join two recordsets into one using DAO 3.6? Thanks for your suggestion. But that is not what I want to do. The two recordsets are actually from 2 different Access MDBs. But both the recordsets have the same fields. ----------------------------------------------------------- Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free! http://www.keen.com
Thu, 30 Jan 2003 03:00:00 GMT

Sean Mage #4 / 5	Join two recordsets into one using DAO 3.6? You could try creating a temporary table and inserting the two recordets, then use a select query. You can set up indexes on the temp table to prevent duplicates if required. Quote: > Thanks for your suggestion. But that is not what I want to do. > The two recordsets are actually from 2 different Access MDBs. > But both the recordsets have the same fields. > ----------------------------------------------------------- > Got questions? Get answers over the phone at Keen.com. > Up to 100 minutes free! > http://www.keen.com
Fri, 31 Jan 2003 03:00:00 GMT

Warren Youn #5 / 5	Join two recordsets into one using DAO 3.6? You might ahve some luck with a union. (This may need some adjustment for Access) "SELECT * FROM tbRen" & _ "UNION ALL" & _ "SELECT * FROM tbStimpy" This would need some work if pulling the stuff from two different databases, but a union is the basic idea I'd shoot for. Quote: > Hi, > I am using DAO 3.6 with Access Database in VB6. I would like to > know if there is anyway to join two recordsets into a new > recordset or merge one recordset into another. > Thanks in advance for any help. > ----------------------------------------------------------- > Got questions? Get answers over the phone at Keen.com. > Up to 100 minutes free! > http://www.keen.com
Mon, 03 Feb 2003 03:00:00 GMT

Page 1 of 1

[ 5 post ]