>>>>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.
>
>Rebecca,
>
>Excel has nothing to do with the solution suggested in that thread. In fact, the first step was to save Excel file as tab-delimited. So, in your case the first step is already done and you may proceed with other steps <g>
>
>I actually recently used Cetin's technique to move Excel file with memo fields into the table. But in my case luckily I had just few fields.

Thanks so much....I will look carefully at the thread and see if it will work for me. I certainly haven't been able to figure it out myself!
Rebecca