PC Review


Reply
Thread Tools Rate Thread

Copy data from tables..

 
 
Patrick
Guest
Posts: n/a
 
      3rd Sep 2003
HI!
I'm looking for a way to program in VBA a series of copy
from different tables to a temp table.

I've got a total of 7 tables right now. Each one of them
are identical in the type of data the keep.

I want to cycle through all of them and pickup for example
all the vendor's names,clients name and Client ID.
And copy this info into my temp table.

After all the cycling is done I will print a report based
on the data inside my temp table.

And finnally,I will delete the data inside my table for
another use later on.

I can print and delete put could you let me know Of a way
to do my copying.

Thank you,

Patrick...

 
Reply With Quote
 
 
 
 
Patrick
Guest
Posts: n/a
 
      3rd Sep 2003
Thank you very much its working.I never though that UNION
was good for this type of work.And no more temp table.
So can I make A UNION has complicated I it could be when
I'm just using a select for example. How far can I go,any
restrictions!!

THank again!

>-----Original Message-----
>Hi Patrick,
>
>Not sure if I understand this...are you, in essence,
>trying to make a 'master' list? So, you'll want a

listing
>of all the vendor_names, client_names, and client_ids (no
>duplicates). If so, I think your best bet would be a
>UNION query...if you want to keep all the duplicates, use
>a UNION ALL. Something like so:
>
>Select vendor_name, client_name, client_id from table1
>UNION
>Select vendor_name, client_name, client_id from table2
>UNION
>Select ......and so on for the rest of the tables;
>
>I wouldn't necessarily be copying this data into another
>table unless it's absolutely necessary (in which case you
>can use a make-table query). You can use this query as
>your recordsource for your report.
>
>Regards,
>Jen
>
>
>>-----Original Message-----
>>HI!
>>I'm looking for a way to program in VBA a series of copy
>>from different tables to a temp table.
>>
>>I've got a total of 7 tables right now. Each one of them
>>are identical in the type of data the keep.
>>
>>I want to cycle through all of them and pickup for

>example
>>all the vendor's names,clients name and Client ID.
>>And copy this info into my temp table.
>>
>>After all the cycling is done I will print a report

based
>>on the data inside my temp table.
>>
>>And finnally,I will delete the data inside my table for
>>another use later on.
>>
>>I can print and delete put could you let me know Of a

way
>>to do my copying.
>>
>>Thank you,
>>
>>Patrick...
>>
>>.
>>

>.
>

 
Reply With Quote
 
TC
Guest
Posts: n/a
 
      4th Sep 2003

"Patrick" <(E-Mail Removed)> wrote in message
news:07f301c37231$be1ea830$(E-Mail Removed)...
(snip)
> I've got a total of 7 tables right now. Each one of them
> are identical in the type of data the keep.



You need to read this article:

http://support.microsoft.com/support...es/Q100139.ASP

HTH,
TC



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy field between tables during data entry Steve Lowe Microsoft Access Forms 3 14th Feb 2007 03:57 AM
Copy data from one database to another from several tables ThomasK via AccessMonster.com Microsoft Access Getting Started 3 5th Apr 2006 03:09 PM
Copy or BackUp data from linked tables =?Utf-8?B?U2lk?= Microsoft Access External Data 4 27th Mar 2005 06:31 PM
copy data - tables rekoop Microsoft Access Database Table Design 1 4th May 2004 03:18 PM
Copy data from two tables Jim Microsoft Access Queries 11 14th Nov 2003 01:27 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:08 AM.