Re: How to loop (copy) information from one database to antoher

Tech-Archive recommends: Fix windows errors by optimizing your registry



I think the best way - is to build Append (Insert Into) query and use it in your code

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

"Andreas" <Andreas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:D48F2E0C-8D78-4DD0-B9E9-3AF964F69E16@xxxxxxxxxxxxxxxx
I would like to loop my information (Some elected fields) using VB from two
big tabels containing 125 000 rows each into a new database, how do I do? How
to I make VB perform the requested task?

.



Relevant Pages

  • Re: Still having problems with CDO
    ... Best regards, ... Alex Dybenko (MVP) ... "SHIPP" wrote in message ...
    (microsoft.public.access.modulesdaovba)
  • Re: Is one of these forms open?
    ... Best regards, ... Alex Dybenko (MVP) ... Const conDesignView = 0 ...
    (microsoft.public.access.modulesdaovba)
  • Re: SQL not working
    ... Best regards, ... Alex Dybenko (MVP) ... > Function MergeStatusUpdates(E_Reference As String, ...
    (microsoft.public.access.modulesdaovba)
  • Re: table design
    ... Yes, this could a reason. ... Best regards, ... Alex Dybenko (MVP) ...
    (microsoft.public.access.modulesdaovba)
  • Re: About vba method
    ... Best regards, ... Alex Dybenko (MVP) ... AddressOf code you found - is for Access 97. ...
    (microsoft.public.access.modulesdaovba)