How to copy 218,388 rows from Access and put in to Excel

C

CyberTaz

Just the fact that you're using Access indicates that you're on a Windows
box & this group is for Mac Excel. You'll get a more detailed explanation &
perhaps some options if you post to a PC Excel or Access group: Start
looking here:

http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

And use the Message area (big whit box) to describe your situation in
detail - including software versions. Just jamming something into the
Subject field doesn't help anyone help you:)

In a nutshell, Excel worksheets (2003 & prior) have only 64,556 rows so you
can't paste more records than that in one fell swoop. Depending on what
you're trying to accomplish, however, there may be suggestions for
alternatives to copy/paste - and far better ones at that.
 
C

CyberTaz

In a nutshell, Excel worksheets (2003 & prior) have only 64,556 rows
Click to expand...

Sorry - fingers move faster than the mind - it should be 65,536 rows:-}

Regards |:>)
Bob Jones
[MVP] Office:Mac
 
J

Jim Gordon MVP

Hi Jen,

If you are using any version of Excel that's older than Excel 2007 the
maximum number of rows on each worksheet is limited to 65,536.

You would have to bring the data into Excel in batches until you got it all
into Excel.

Excel 2007 (Windows) can handle about a million rows. You can import using
Microsoft Query (Get External Data).

If you attempt to open a 2007 workbook that has more than 65,536 rows on a
worksheet, the rows past 65,536 will be lost, however.

There's no word yet on whether or not Excel 2008 will support more than
65,536 rows.

-Jim


Quoting from "Jenb1" <[email protected]>, in article
(e-mail address removed), on [DATE:


--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Integrating information from Word to Excel (not mail merge) 1
Repeating a row other than the 1st row as the header row in a table from next page 1
Merging from an Excel file with graphics 1
Copy addition formula of non-consecutive horizontal cells 2
Need Help with a VBA subroutine 0
Paste to excel from word - auto format problem 1
Autonumber field in Excel that behaves the same as Access 0
Copying table from Excel to Publisher 1

Top