Welcome to MacBoardz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

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

  
   Macintosh computer (Home) -> Excel RSS
Next:  leopard and excel view and print problems  
Author Message
Jenb1

External


Since: Nov 05, 2007
Posts: 1



(Msg. 1) Posted: Mon Nov 05, 2007 9:26 am
Post subject: How to copy 218,388 rows from Access and put in to Excel
Archived from groups: microsoft>public>mac>office>excel (more info?)
--
Jen Brown

 >> Stay informed about: How to copy 218,388 rows from Access and put in to Excel 
Back to top
Login to vote
CyberTaz

External


Since: Apr 06, 2006
Posts: 351



(Msg. 2) Posted: Mon Nov 05, 2007 12:51 pm
Post subject: Re: How to copy 218,388 rows from Access and put in to Excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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.
--
HTH |:>)
Bob Jones
[MVP] Office:Mac

"Jenb1" wrote in message

>
> --
> Jen Brown

 >> Stay informed about: How to copy 218,388 rows from Access and put in to Excel 
Back to top
Login to vote
CyberTaz

External


Since: Jul 20, 2005
Posts: 1017



(Msg. 3) Posted: Tue Nov 06, 2007 6:46 am
Post subject: Re: How to copy 218,388 rows from Access and put in to Excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On 11/5/07 12:51 PM, in article e6Dk0R9HIHA.1204 DeleteThis @TK2MSFTNGP03.phx.gbl,
"CyberTaz" <typegeneraltaz1ATcomcastdotnet> wrote:

> In a nutshell, Excel worksheets (2003 & prior) have only 64,556 rows

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

Regards |:>)
Bob Jones
[MVP] Office:Mac
 >> Stay informed about: How to copy 218,388 rows from Access and put in to Excel 
Back to top
Login to vote
Jim Gordon MVP

External


Since: Mar 01, 2004
Posts: 1165



(Msg. 4) Posted: Sat Nov 10, 2007 3:21 pm
Post subject: Re: How to copy 218,388 rows from Access and put in to Excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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" , in article
AA53D4E7-687A-4AC0-BAB4-39D3CFD6061F.DeleteThis@microsoft.com, on [DATE:


--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info http://mvp.support.microsoft.com/
 >> Stay informed about: How to copy 218,388 rows from Access and put in to Excel 
Back to top
Login to vote
Scott_Persons

External


Since: Mar 10, 2008
Posts: 1



(Msg. 5) Posted: Mon Mar 10, 2008 7:57 am
Post subject: Re: How to copy 218,388 rows from Access and put in to Excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Does the 2008 Excel for Mac have this 65,536 row limitation?
 >> Stay informed about: How to copy 218,388 rows from Access and put in to Excel 
Back to top
Login to vote
Bob Greenblatt

External


Since: Mar 06, 2008
Posts: 2



(Msg. 6) Posted: Mon Mar 10, 2008 9:08 pm
Post subject: Re: How to copy 218,388 rows from Access and put in to Excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
No. Excel 2008 has 1 million rows

--
Bob Greenblatt [MVP]
bobgreenblattATmsnDOTcom
wrote in message

> Does the 2008 Excel for Mac have this 65,536 row limitation?
 >> Stay informed about: How to copy 218,388 rows from Access and put in to Excel 
Back to top
Login to vote
Jim Gordon MVP

External


Since: Mar 03, 2008
Posts: 17



(Msg. 7) Posted: Mon Mar 10, 2008 9:41 pm
Post subject: Re: How to copy 218,388 rows from Access and put in to Excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Scott_Persons.TakeThisOut@officeformac.com wrote:
> Does the 2008 Excel for Mac have this 65,536 row limitation?


Hi,

Excel 2008 has more than 1 million rows.

Here's a way to bring those access rows into Excel:
http://www.agentjim.com/MVP/Excel/Office2004andAccess.doc

-Jim

--
Jim Gordon
Mac MVP

MVPs are independent experts who are not affiliated with Microsoft.
http://mvp.support.microsoft.com/
 >> Stay informed about: How to copy 218,388 rows from Access and put in to Excel 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Why can't I get more than 16,384 rows in Excel X for Mac? - I want to creat a big spreadsheet with multiple columns and over 36,000 rows, but I can't seem to do it in my Excel X for the Mac. Here's the situation: I have received a large spreadsheet in three parts from my a*ociate who has saved it in Microsoft....

Duplicating Rows in Excel 2001 for the Mac - I wonder if anyone can help me? In Excel 98 from Office98 , I was able to duplicate a row in a spreadsheet as follows:- 1.Highlight the row in question 2. Hold down the Apple key + C key + I key (as in India) and hey presto a duplicated line However i...

Duplicating Rows in Excel 2001 for the Mac (revised group) - I wonder if anyone can help me? In Excel 98 from Office98 , I was able to duplicate a row in a spreadsheet as follows:- 1.Highlight the row in question 2. Hold down the Apple key + C key + I key (as in India) and hey presto a duplicated line ..

Excel: Insert Multiple Blank Rows -

Excel X spreadsheet rows and columns too narrow - I recently installed Office X on a G4 with OS 10.3.5. When I open = Excel, the=20 default spreadsheet rows and columns are extremely narrow. I've seen = this=20 same behavior in Excel for Windows but I forgot how to remedy it. Any=20 suggestions would...
   Macintosh computer (Home) -> Excel All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]