Re: VB.Net (ADO): Thoughts on Copying 7 tables to 1 table
From: Mr. B (User_at_NoWhere.com)
Date: 10/23/04
- Next message: Johny: "Problem with execution"
- Previous message: NIL: "RE: Can anybody show me how to open up a DAO connection to an Access d"
- In reply to: NIL: "RE: VB.Net (ADO): Thoughts on Copying 7 tables to 1 table"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 23 Oct 2004 19:02:40 GMT
With Deft Fingers, NIL <NIL@discussions.microsoft.com> wrote:
>You can write a QUERY that uses UNION and execute it to copy all the data in
>7 Tables to the new table.
>
>select col1, col2, col3 from table1
>UNION
>select col1, col2, col3 from table2
>UNION
>..
>..
>select col1, col2, col3 from table7
Verrrry interesting. My ADO bood (by David Sceppa) doesn't have anything on
UNION. I'll dig into this a bit more and find out about it as it sounds just
what I need...
Many thanks for the tip!
Bruce
- Next message: Johny: "Problem with execution"
- Previous message: NIL: "RE: Can anybody show me how to open up a DAO connection to an Access d"
- In reply to: NIL: "RE: VB.Net (ADO): Thoughts on Copying 7 tables to 1 table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
