Hello All!
I am trying to merge two tables from two different MDB's into one. I know I
can just append the records from the second table into the first or vice
versa, which will suffice in my situation, however, I'm not sure what the
the correct way to do it.
here i smy thinking on it, generate a rs from the second table, close the
ADO connection and open another ado connection to the second MDB, and append
this record set, however, do I have to set the RS's active connection to the
new connection?
TIA
Luis 5 1076
You should put your question into the ADO newsgroup rather than the VB.NET
Thanx - OHM
"Anon" <an**@anon.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl... Hello All! I am trying to merge two tables from two different MDB's into one. I know
I can just append the records from the second table into the first or vice versa, which will suffice in my situation, however, I'm not sure what the the correct way to do it. here i smy thinking on it, generate a rs from the second table, close the ADO connection and open another ado connection to the second MDB, and
append this record set, however, do I have to set the RS's active connection to
the new connection?
TIA Luis
Hi Anon,
In addition from OHM,
microsoft.public.data.ado
is an Ado newsgroup.
Cor
Sorry guys, I didn't know it existed! Thanks!
"Cor Ligthert" <no**********@planet.nl> wrote in message
news:Oq*************@TK2MSFTNGP11.phx.gbl... Hi Anon,
In addition from OHM,
microsoft.public.data.ado
is an Ado newsgroup.
Cor
It is good to see you back OHM
"One Handed Man ( OHM#)" <news.microsoft.com> wrote in message
news:#c*************@tk2msftngp13.phx.gbl: You should put your question into the ADO newsgroup rather than the VB.NET
Thanx - OHM
"Anon" <an**@anon.com> wrote in message news:%2****************@TK2MSFTNGP11.phx.gbl... Hello All! I am trying to merge two tables from two different MDB's into one. I know I can just append the records from the second table into the first or vice versa, which will suffice in my situation, however, I'm not sure what the the correct way to do it. here i smy thinking on it, generate a rs from the second table, close the ADO connection and open another ado connection to the second MDB, and append this record set, however, do I have to set the RS's active connection to the new connection?
TIA Luis
Thanks Scorp
"scorpion53061" <ad***@nospampleasekjmsolutions.com> wrote in message
news:OQ**************@TK2MSFTNGP12.phx.gbl... It is good to see you back OHM
"One Handed Man ( OHM#)" <news.microsoft.com> wrote in message news:#c*************@tk2msftngp13.phx.gbl: You should put your question into the ADO newsgroup rather than the VB.NET
Thanx - OHM
"Anon" <an**@anon.com> wrote in message news:%2****************@TK2MSFTNGP11.phx.gbl... Hello All! I am trying to merge two tables from two different MDB's into one. I know I can just append the records from the second table into the first or vice versa, which will suffice in my situation, however, I'm not sure what the the correct way to do it. here i smy thinking on it, generate a rs from the second table, close the ADO connection and open another ado connection to the second MDB, and append this record set, however, do I have to set the RS's active connection to the new connection?
TIA Luis
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Patchwork |
last post by:
Hi Everyone,
Please take a look at the following (simple and fun) program:
////////////////////////////////////////////////////////////////////////////
/////////////
// Monster Munch, example...
|
by: Proteus |
last post by:
Any help appreciated on a small perl project I need to write for
educator/teaching purposes. I have not programmed perl for some time, need
to get up to speed, maybe some kind souls hrere will help...
|
by: Raskolnikow |
last post by:
Hi!
I have a very simple problem with itoa() or the localtime(...).
Sorry, if it is too simple, I don't have a proper example.
Please have a look at the comments.
struct tm *systime;
time_t...
|
by: Peter |
last post by:
Hello
Thanks for reviewing my question. I would like to know how can I programmatically select a node
Thanks in Advanc
Peter
|
by: abcd |
last post by:
I am trying to set up client machine and investigatging which .net
components are missing to run aspx page.
I have a simple aspx page which just has "hello world" printed....
When I request...
| |
by: dba_222 |
last post by:
Dear Experts,
Ok, I hate to ask such a seemingly dumb question, but I've
already spent far too much time on this. More that I
would care to admit.
In Sql server, how do I simply change a...
|
by: Giancarlo Berenz |
last post by:
Hi:
Recently i write this code:
class Simple
{
private:
int value;
public:
int GiveMeARandom(void);
|
by: galiorenye |
last post by:
Hi,
Given this code:
A** ppA = new A*;
A *pA = NULL;
for(int i = 0; i < 10; ++i)
{
pA = ppA;
//do something with pA
|
by: Phillip Taylor |
last post by:
Hi guys, I'm looking to develop a simple web service in VB.NET but I'm
having some trivial issues. In Visual Studio I create a web services
project and change the asmx.vb file to this:
Imports...
|
by: Chris M. Thomasson |
last post by:
I use the following technique in all of my C++ projects; here is the example
code with error checking omitted for brevity:
_________________________________________________________________
/*...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |