Extracting Data

[CBragg]

Ive imported a text file into a table. The trouble is it has put all the information into one field. There are 3 rows of data with a blank record either side of this. I want to be able to put each seperate row into its own field in a new table. Then i want to delete all blank records.

Any ideas would be helpfull !

Thanks in advance.

 

[FoFa]

Sounds like you used the wrong kind of import. If it is truly delimited, make sure you specify the delimiter and any other information. If it is a fixed length tyope of record, make sure you define all the fields and their length. You can use a specification if you want also, but the wizard usually is more than sufficient for that task if it is a one time thing.