Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Csv file over 2GB
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Vista
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01523315
Message ID:
01523316
Views:
87
2GB is limitation of Windows 32-bit API that VFP is using so it's affects the size of any file in VFP.

>I have a csv file that I have been processing for years. The first step is using an append statement to get the first set of records I need into a vfp table, then other processing after that.
>
>This file grows with every new version (once a week). Last week the file finally reached 2GB in size. The append statement generated an error saying file too large.
>
>I take it the 2GB limit does not just apply tables, but other data file types as well?
>
>I am trying to re-write some of the routines in sql server, but finding the processing from a raw csv file to be slower than what vfp was able to do...
>
>Thanks,
>KP
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform