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