If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Corel Paradox > export to excel from P9

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 11-03-09, 20:50
Govert Govert is offline
Registered User
 
Join Date: Nov 2009
Location: Rotterdam
Posts: 2
Question export to excel from P9

Hi ,
In one of my applications i export a table to excel.
That worked fine, however ...
The table gets bigger and bigger and the export option in P9 will only export some 16000 records.
The table grows with 2000 records each month, so after July i am in trouble.
The whole process starts again in January.
Of course there is a way around it by splitting the table, do 2 exports and combine the 2 worksheets later in excel.
But that requieres manual intervention.
The question is :
Is there a way around this limit of 16K ?
Does anyone have a piece of code (or an excel macro) that does the job of exporting in one go unattended ?
Thanks in advance, Govert
Reply With Quote
  #2 (permalink)  
Old 11-04-09, 07:03
Steve Green Steve Green is offline
Registered User
 
Join Date: Dec 2007
Posts: 273
export from paradox as csv.. import the csv in excel..
__________________
--
Steven Green - Myrtle Beach, South Carolina USA

http://www.OasisTradingPost.com

Oasis Trading Post
- Collectibles and Memorabilia
- Vintage Lego Sets and Supplies
Reply With Quote
  #3 (permalink)  
Old 11-04-09, 07:53
Govert Govert is offline
Registered User
 
Join Date: Nov 2009
Location: Rotterdam
Posts: 2
Smile thank you

thank you, thank you (the message was too short)
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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