You might also try using gateway to import the data. Use the gateway wizard to create a specification file. Edit the specification file as below: 7E is the hex code for the tilde character.
RecordSeparator=7E Dennis McGrath
You might also try using gateway to import the data. Use the gateway wizard to create a specification file. Edit the specification file as below: 7E is the hex code for the tilde character.
RecordSeparator=7E Dennis McGrath