Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
importing csv files, problem with date formats jiwolf Excel Worksheet Functions 5 March 7th 06 12:48 AM
I NEED TO IMPORT MORE THAN THE 65,536 LINES EXCEL ALLOWS PAULP Excel Worksheet Functions 3 February 2nd 06 05:19 PM
import data with macro chris_rip Excel Discussion (Misc queries) 0 July 18th 05 08:40 PM
User Defined Variables in MS query cause a problem to import data snb Excel Discussion (Misc queries) 0 April 13th 05 12:16 AM
import problem on huge xls file f_huba@toplita. Excel Worksheet Functions 2 November 5th 04 12:09 AM


All times are GMT +1. The time now is 11:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"