CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Help/Consulting -> Help - Jobs Wanted

 Access Apprentice:-)

Print topic Send  topic

Author Message
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
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.