View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
AlexanderGross
 
Posts: n/a
Default Word does imports just the first column of a CSV data set

Hi Peter,

"Peter Jamieson" wrote:
Try checking the "Show All" box in the "Confirm Data Source dialog, then
selecting "Text Files (*.txt)" instead of the OLEDB option. This is (I
think) the option Word actually uses if you uncheck Word
Tools|Options|General|Confirm conversion at open" before opening the data
source, and the option should really be listed for .csv data sources.


Show All-*. txt actually does the trick. Thank you very much! Who thinks
TXT is equal to CSV when it comes to importing data? Weird.

I've also tried to unchecking Tools|Options|General|Confirm conversion at
open and it also worked like a charm. This is even a better approach because
I don't have to remember to select text files.

Thanks again,

Alex