Visual FoxPro 6.0 troubles exporting large files to excel

0 pts.
Tags:
excel
Excel import/export
FoxPro
FoxPro 6
Visual FoxPro 6
I have large databases that need to be sent to customers in a manifest.  So i export it from FoxPro six to excel 5.0 and save it in my documents then attach it to an e-mail. The trouble i am having is exporting a large database.  FoxPro does not export the whole thing when i export it. It stops at like 16,000 something entries and there are over 30,000 in the database i need to export.  If there is anyway i can send the whole file or send it in two separate attachments I would aprreciate any information on how to do this. 

Software/Hardware used:
Visual FoxPro 6.0
ASKED: August 17, 2010  1:17 PM
UPDATED: August 17, 2010  7:47 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

FoxPro retains an old Excel limit of 16k records. As a workaround, export to CSV format; you can import into Excel or use a text editor (e.g., Wordpad) to split that file manageable chunks.

Note that on reading into Excel, you have to be careful of column formats. Particularly if you have text columns that are all-numeric (e.g., stock or item numbers), Excel will interpret them as numbers. Ensure that you properly select the column format in the import wizard.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • I asked about exporting large files from fox pro 6.0 to excel because my computer was cutting off large data base i am trying to export. This is the answer you gave me: Excel is stopping at 16k records. As a workaround, export to CSV format; you can then use a text editor (e.g., Wordpad) to split that file into Excel-manageable chunks. My problem now is that I tried to export it to CSV format but my computer does not show that for an option. So is there another option? Thank you.
    0 pointsBadges:
    report
  • [...] Visual FoxPro 6.0 troubles exporting large files to excel No [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following