So you don't want the rest of the 1993 fields?
Seems like you wouldn't WANT this as a RDBMS record as it's gagging to be normalised.
Why can't VFP import? Too many fields?
You can APPEND FROM with a field list.
>Hi everybody,
>
>I have a table in text format. This table has more than 2000 fields. Suppose something like this:
>
>Name Type Engine FromTime ToTime StateParked StateService StateBroken …State3000
>
>Car1 Honda 2.0 1 100 10 1 17 .......
>Car2 BMW 3.0 1 100 6 9 8 .......
>Car3 Acura 2.1 6 90 19 17 19 .......
>
>VFP can not import this file and I do not want to deal with 3000 fields, so I would like to convert these fields to records.
>
>I would like to import this text file into FoxPro with the following format:
>
>
>Name Type Engine TimeFrom TimeTo State DurationTime
>Car1 Honda 2.0 1 100 Parked 10
>Car1 Honda 2.0 1 100 Service 11
>Car1 Honda 2.0 1 100 Broken 17
>Car2 BMW 3.0 1 100 Parked 6
>Car2 BMW 3.0 1 100 Service 9
>Car2 BMW 3.0 1 100 Broken 8
>Car2 Acura 2.1 6 90 Parked 19
>Car2 Acura 2.1 6 90 Service 17
>Car2 Acura 2.1 6 90 Broken 19
>
>Does anyone have a good idea for doing this?
>
>Thanks a lot,
>Ali
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.