copy and paste

[Guest]

Hi,

I want to copy the contents of a query into a new table. However Access (or
Windows) keeps telling me that I have exceeded the max number of rows I can
copy - does anyone know the limit or a work around for say upto 750,000 rows.

Thanks

Reggiee

 

[Brendan Reynolds]

Use an append query instead of copy and paste.

 

[Guest]

Thanks Brendan but what do you mean by an append query?

Reggiee

 

[Brendan Reynolds]

Here's a link to an on-line article on the subject ...

http://office.microsoft.com/en-gb/assistance/HA011860631033.aspx

 

[Guest]

tops

Thanks

Here's a link to an on-line article on the subject ...

http://office.microsoft.com/en-gb/assistance/HA011860631033.aspx