basic txt import problem
 

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

Title, Description, Reference, Id, State, FirstName, Email
"The Blue Book","<UL<LITypes of Clouds
<LIOn shelf</UL
","# "

"The Red Book","<UL<LIThe Start if Fire
<LIOn shelf</UL
","# "
_______________________________

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
<LIOn shelf</UL
,# 502"


--
Deljo
------------------------------------------------------------------------
Deljo's Profile: http://www.excelforum.com/member.php...o&userid=37078
View this thread: http://www.excelforum.com/showthread...hreadid=568015

basic txt import problem
 

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


--
Deljo
------------------------------------------------------------------------
Deljo's Profile: http://www.excelforum.com/member.php...o&userid=37078
View this thread: http://www.excelforum.com/showthread...hreadid=568015