basic txt import problem

[Deljo]

This does not want to import into Excel, can anyone tell me why?
_______________________________

Title, Description, Reference, Id, State, FirstName, Email
"The Blue Book","<UL><LI>Types of Clouds
<LI>On shelf</UL>
","# 502","5000","OH","Mark","(e-mail address removed)"

"The Red Book","<UL><LI>The Start if Fire
<LI>On shelf</UL>
","# 503","6000","OH","Ray","(e-mail address removed)"
_______________________________

Using Delimited > comma (checked)

(formatted columns contain data out of their columns)
*What are the right settings?*--------------------
First col presently reads:

Title
The Blue Book
<LI>On shelf</UL>
,# 502"

 

[Deljo]

PLEASE DISREGARD POST - PROBLEM was in multiple lines per field. So di
in access