Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default More than 65,000 records for Excel 2007 problems!

Hello I have office 2007 on a XP platform, I’m having major problems
in exporting 100,000s of records from my Access 2007 into Excel 2007?
This should not be a problem for office 2007, any ideas?

kind regards

J S Dhuga
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 208
Default More than 65,000 records for Excel 2007 problems!

The # of rows Excel 07 can deal with is limited to the amount of RAM
in your PC.

Maybe instead of exporting the rows into Excel, export them into
another Access Database and run your analyses from there.

On Jun 16, 9:30 am, wrote:
Hello I have office 2007 on a XP platform, I’m having major problems
in exporting 100,000s of records from my Access 2007 into Excel 2007?
This should not be a problem for office 2007, any ideas?

kind regards

J S Dhuga


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,389
Default More than 65,000 records for Excel 2007 problems!

What's the problem? Doesn't import all the records? Hangs up? Stops at
65,000 rows? Are you in compatibility mode?

We need a description of the problem before we can find a solution.

Regards,
Fred.

wrote in message
...
Hello I have office 2007 on a XP platform, I’m having major problems
in exporting 100,000s of records from my Access 2007 into Excel 2007?
This should not be a problem for office 2007, any ideas?

kind regards

J S Dhuga

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XY Scatter-problems with large data records DataGeek Excel Discussion (Misc queries) 1 May 28th 08 09:53 PM
Two problems with Excel 2007 Pygmalion Excel Discussion (Misc queries) 0 October 22nd 07 08:34 AM
Excel 2007 - need to mark, not remove, duplicate records. DDAI Consult Excel Discussion (Misc queries) 4 August 22nd 07 07:50 PM
Excel 2007 Problems [email protected] Excel Discussion (Misc queries) 1 March 5th 07 07:30 PM
What is the Max number of records/row allowed in Excel 2007 jrm Excel Discussion (Misc queries) 7 January 3rd 07 02:46 AM


All times are GMT +1. The time now is 03:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"