Trying to merge a csv file to a word document -- ASAP PLEASE

[DH]

I am currently working on a database testing project that
is outputting a csv file instead of a spreadsheet with
headers. The csv output is for a mail merge word document
and I need to figure out how to merge the csv file to the
word document to see the csv information -- can some one
help me?

 

[Doug Robbins]

Save the csv file as a text file and use that as the datasource.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[DH]

I have tried this but I get an error message of
"too few fields" even though the text file is huge.

 

[Pete Bennett]

You'll need to make sure that the data is consistant.

I've had problems in my CSV files sometimes that the return codes have been
mismatches. Ones in the middle of multi-line fields were chr(10) and the end
of records were chr(13) + chr(10) and Word ended up throwing out those
records.

Excel seems to be especially good at outputting inconsistant CSV files...

 

[RV]

i'm having the same problem, when i load the word document in word it is
good, the merge succeeds, when I load the word document with visual basic the
merge fails, the complete string is one field instead of many fields