copy and paste

Reggiee · Mar 30, 2006

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 · Mar 30, 2006

Use an append query instead of copy and paste.

Reggiee · Apr 3, 2006

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

Reggiee

Brendan Reynolds · Apr 3, 2006

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

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

Reggiee · Apr 3, 2006

tops

Thanks

Brendan Reynolds said:
Here's a link to an on-line article on the subject ...

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