Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Access
3rdpartyusrgrp
access
activexcontrol
adp.sqlserver
commandbarsui
conversion
dataaccess.pages
developers.toolkitode
devtoolkits
externaldata
forms
formscoding
gettingstarted
internet
interopoledde
macros
modulescoding
modulesdaovba
modulesdaovba.ado
multiuser
odbcclientsvr
queries
replication
reports
security
setupconfig
tablesdbdesign
  
 
date: Tue, 26 Aug 2008 05:55:01 -0700,    group: microsoft.public.access.externaldata        back       


Export Access table to Excel that has more than 65000 records    
Office 2007.  I cannot seem to export an Access 2007 table into Excel 2007 
that has more than 65,000+ records.  It stops and gives me an error.  
Shouldn't I be able to export all 95,000 rows in my Access 2007 table into 
Excel 2007 with the new row limits?
date: Tue, 26 Aug 2008 05:55:01 -0700   author:   duketter

Re: Export Access table to Excel that has more than 65000 records    
There is a 65,536 row limit in Excel.  See this thread.  

http://www.accessmonster.com/Uwe/Forum.aspx/access-externaldata/10215/Urgent-How-to-export-more-than-65535-rows-to-Excel


You will have to split it.

Bonnie
http://www.dataplus-svc.com

duketter wrote:
>Office 2007.  I cannot seem to export an Access 2007 table into Excel 2007 
>that has more than 65,000+ records.  It stops and gives me an error.  
>Shouldn't I be able to export all 95,000 rows in my Access 2007 table into 
>Excel 2007 with the new row limits?

-- 
Message posted via http://www.accessmonster.com
date: Tue, 26 Aug 2008 13:05:00 GMT   author:   bhicks11 via AccessMonster.com u44327@uwe

Re: Export Access table to Excel that has more than 65000 records    
I am using Excel 2007 which has a 1,000,000+ row limit.  The older Excel had 
the row limit of 65,536.

"bhicks11 via AccessMonster.com" wrote:

> There is a 65,536 row limit in Excel.  See this thread.  
> 
> http://www.accessmonster.com/Uwe/Forum.aspx/access-externaldata/10215/Urgent-How-to-export-more-than-65535-rows-to-Excel
> 
> 
> You will have to split it.
> 
> Bonnie
> http://www.dataplus-svc.com
> 
> duketter wrote:
> >Office 2007.  I cannot seem to export an Access 2007 table into Excel 2007 
> >that has more than 65,000+ records.  It stops and gives me an error.  
> >Shouldn't I be able to export all 95,000 rows in my Access 2007 table into 
> >Excel 2007 with the new row limits?
> 
> -- 
> Message posted via http://www.accessmonster.com
> 
>
date: Tue, 26 Aug 2008 06:26:01 -0700   author:   duketter

Re: Export Access table to Excel that has more than 65000 records    
Your right - I bet it has something to do with Excel compatibility mode.  In
your export from Access are you selecting 07?  I'm just tossing ideas out.

Bonnie
http://www.dataplus-svc.com

duketter wrote:
>I am using Excel 2007 which has a 1,000,000+ row limit.  The older Excel had 
>the row limit of 65,536.
>
>> There is a 65,536 row limit in Excel.  See this thread.  
>> 
>[quoted text clipped - 9 lines]
>> >Shouldn't I be able to export all 95,000 rows in my Access 2007 table into 
>> >Excel 2007 with the new row limits?

-- 
Message posted via http://www.accessmonster.com
date: Tue, 26 Aug 2008 14:09:52 GMT   author:   bhicks11 via AccessMonster.com u44327@uwe

Re: Export Access table to Excel that has more than 65000 records    
How exactly are you exporting the records to Excel. As you said, Excel 2007 
can hold a million rows. However hitting a limit of 65000 records looks 
suspiciously like the export is in something like Excel 2003 or earlier.
-- 
Jerry Whittle, Microsoft Access MVP 
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"duketter" wrote:

> I am using Excel 2007 which has a 1,000,000+ row limit.  The older Excel had 
> the row limit of 65,536.
> 
> "bhicks11 via AccessMonster.com" wrote:
> 
> > There is a 65,536 row limit in Excel.  See this thread.  
> > 
> > http://www.accessmonster.com/Uwe/Forum.aspx/access-externaldata/10215/Urgent-How-to-export-more-than-65535-rows-to-Excel
> > 
> > 
> > You will have to split it.
> > 
> > Bonnie
> > http://www.dataplus-svc.com
> > 
> > duketter wrote:
> > >Office 2007.  I cannot seem to export an Access 2007 table into Excel 2007 
> > >that has more than 65,000+ records.  It stops and gives me an error.  
> > >Shouldn't I be able to export all 95,000 rows in my Access 2007 table into 
> > >Excel 2007 with the new row limits?
> > 
> > -- 
> > Message posted via http://www.accessmonster.com
> > 
> >
date: Tue, 26 Aug 2008 08:12:00 -0700   author:   Jerry Whittle

Re: Export Access table to Excel that has more than 65000 records    
duketter wrote:
> I am using Excel 2007 which has a 1,000,000+ row limit.  The older
> Excel had the row limit of 65,536.

OutputTo always assumes Excel 97 format.  Use the TransferSpreadsheet method 
instead which lets you specify the Excel version.

-- 
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com
date: Tue, 26 Aug 2008 19:14:03 -0500   author:   Rick Brandt

Re: Export Access table to Excel that has more than 65000 records    
Good catch Rick.  Wondered if it was something like that but couldn't put my
finger on it.

Bonnie
http://www.dataplus-svc.com

Rick Brandt wrote:
>> I am using Excel 2007 which has a 1,000,000+ row limit.  The older
>> Excel had the row limit of 65,536.
>
>OutputTo always assumes Excel 97 format.  Use the TransferSpreadsheet method 
>instead which lets you specify the Excel version.
>

-- 
Message posted via http://www.accessmonster.com
date: Wed, 27 Aug 2008 01:51:42 GMT   author:   bhicks11 via AccessMonster.com u44327@uwe

Re: Export Access table to Excel that has more than 65000 records    
Do you know if Microsoft plans to fix this so that you can export directly to 
Excel 2007?  

Also, where do you find the TransferSpreadsheet - I've looked in the Macro 
settings, but was unable to locate.
-- 
Thanks, Cbold


"bhicks11 via AccessMonster.com" wrote:

> Good catch Rick.  Wondered if it was something like that but couldn't put my
> finger on it.
> 
> Bonnie
> http://www.dataplus-svc.com
> 
> Rick Brandt wrote:
> >> I am using Excel 2007 which has a 1,000,000+ row limit.  The older
> >> Excel had the row limit of 65,536.
> >
> >OutputTo always assumes Excel 97 format.  Use the TransferSpreadsheet method 
> >instead which lets you specify the Excel version.
> >
> 
> -- 
> Message posted via http://www.accessmonster.com
> 
>
date: Wed, 19 Nov 2008 09:51:00 -0800   author:   Cbold

Re: Export Access table to Excel that has more than 65000 records    
I think you're find TransferSpreadsheet if you select Show All Actions. Jeff 
Conrad explains at http://accessjunkie.com/faq_02.aspx

Given that you CAN export to Excel 2007 using TransferSpreadsheet (the 
preferred way of dealing with spreadsheets), I doubt you'll find any change 
is planned.

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Cbold"  wrote in message 
news:0A99FA7E-F23A-467E-B4D5-48F818022834@microsoft.com...
> Do you know if Microsoft plans to fix this so that you can export directly 
> to
> Excel 2007?
>
> Also, where do you find the TransferSpreadsheet - I've looked in the Macro
> settings, but was unable to locate.
> -- 
> Thanks, Cbold
>
>
> "bhicks11 via AccessMonster.com" wrote:
>
>> Good catch Rick.  Wondered if it was something like that but couldn't put 
>> my
>> finger on it.
>>
>> Bonnie
>> http://www.dataplus-svc.com
>>
>> Rick Brandt wrote:
>> >> I am using Excel 2007 which has a 1,000,000+ row limit.  The older
>> >> Excel had the row limit of 65,536.
>> >
>> >OutputTo always assumes Excel 97 format.  Use the TransferSpreadsheet 
>> >method
>> >instead which lets you specify the Excel version.
>> >
>>
>> -- 
>> Message posted via http://www.accessmonster.com
>>
>>
date: Wed, 19 Nov 2008 17:18:32 -0500   author:   Douglas J. Steele

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us