LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Importing Data problem

It will tend not to split at a comma if this falls within a text field
enclosed in quotes, but will split otherwise. It gets more complicated if
the field also contains quotes, so if you save as a cvs Excel will double up
the quote marks in this situation.
--
David Biddulph

"Testing" wrote in message
...
There does happen to be a ", space" immediately before where the data
splits
but there are hundreds of those all throughout the data and it doesn't
happen
in those places.


"DaveO" wrote:

I've seen this happen in a text field when the field contains a
punctuation comma that the import perceives as a delimiter. If you
look at the raw file, does that string contain a comma?




 
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
Problem Importing Fixed Width Data [email protected] New Users to Excel 7 September 15th 06 01:42 AM
Problem importing data into sql server database Me Excel Discussion (Misc queries) 1 January 27th 06 01:51 AM
Problem importing data from Access BT Connect Excel Discussion (Misc queries) 2 January 21st 06 04:07 PM
Problem importing external data Teresa Robinson New Users to Excel 0 October 13th 05 09:08 PM
Importing Data & Refresh Data Problem George Excel Discussion (Misc queries) 2 March 28th 05 12:37 AM


All times are GMT +1. The time now is 05: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"