Christos
|
| Posted: 05/24/2004, 2:25 AM |
|
Hello everyone,
Could you please help me with the following problem that I have?
I have something like 80,000 rows of info that I need to work on, but as you know Excel can not support more than 65K rows or so. Therefore, I split the file in two halves which I imported to Access.
In order to start working, I need to join those two tables again, i.e. one UNDER the other. I am stuck because my queries knowledge is limited. Can anyone help?
Many thanks in advance.
|
|
|
 |
ChetG
|
| Posted: 05/24/2004, 6:21 AM |
|
use one table to select from and use that to insert into the other
table...or you could use a union of the 2 if they must remain separate....
insert into taba (select * from tabb)
or
select a.* from taba union select * from tabb
chester
"Christos" <Christos@forum.codecharge> wrote in message
news:2140b1bf8eaaa0e@news.codecharge.com...
> Hello everyone,
>
> Could you please help me with the following problem that I have?
>
> I have something like 80,000 rows of info that I need to work on, but as
you
> know Excel can not support more than 65K rows or so. Therefore, I split
the
> file in two halves which I imported to Access.
>
> In order to start working, I need to join those two tables again, i.e. one
> UNDER the other. I am stuck because my queries knowledge is limited. Can
anyone
> help?
>
> Many thanks in advance.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
pcfountain
Posts: 35
|
| Posted: 05/24/2004, 6:35 AM |
|
In Access, you can also just select the rows (use ctrl-A) and copy-paste into the other table.
_________________
Paul Fountain
http://www.pcfountain.com |
 |
|
|
