I have tried all of this. So maybe I did not set up my database correctly.
I go into data administration and choose import data then Delimited Text and I put my ~ delimiter in and it comes back with
0 records in Delimited ASCII format loaded into movielist.
Here is a sample of my text file:
1~12 Monkeys~Bruce Willis~Brad Pitt~Madeline Stowe~R~Action~Excellent~Video
And the fields in my table are:
Movieid, movietitle, actor,supporting_actor, supporting_actor2, rating,subject, review, videodvd
I created the database using data administration