Visual FoxPro 6.0 troubles exporting large files to excel
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
Software/Hardware used:
Visual FoxPro 6.0
ASKED:
August 17, 2010 1:17 PM
UPDATED:
August 17, 2010 7:47 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
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.