Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table with more than 255 fields.
Message
From
29/03/2007 12:26:45
Rebecca Stottlemire
Kansas State Department of Commerce
Topeka, Kansas, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01209840
Message ID:
01209866
Views:
16
>>I'm in a situation where I have users giving me tab-delimited text files to be imported into a table, from which I'll do reports. However, the format that they send has more than 255 fields.
>>
>>I've been trying to figure out a way to open the text file and split off some of the information into one file, then put the rest in another. I can open them with the FOPEN(), but I haven't had any luck counting tabs to get to where I want to split it.
>>
>>Has anyone had to do this type of thing before?
>>
>>Thanks,
>>Rebecca
>
>See if this Re: Excel to DBF - quickly Thread #506263 Message #506594 will give you some pointers.
>
>And Re: Import text file - more than 256 fields Thread #890295 Message #890321
Thanks for the info. I haven't tried Excel because the files have too many records. I didn't know about Safefopen(), perhaps that will help.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform