Importing Text

[katmando]

I want to import a text file that is one continuous string at present when i try to import the file it treats the data as one row.

I would like to split so that a new row is created wherever an apostrophe
appears in the string IE (') I can use this as the delimiter when importing as one row, but for some reason it creates errors after field 30

I've included a sample of the data

Cheers

 

[Bat17]

Bit of a job to tell without a sample of the text that actualy causes the error. one possibility is that the text is more that 255 long and wont fit in a field.
What error are you getting?

Peter