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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DH - 14 Sep 2004 20:37 GMT

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?

Reply to this Message

Doug Robbins - 15 Sep 2004 02:12 GMT

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

Signature

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

>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?

Reply to this Message

DH - 15 Sep 2004 13:56 GMT

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

>-----Original Message-----
>Save the csv file as a text file and use that as the datasource.
[quoted text clipped - 7 lines]
>
>.

Reply to this Message

Pete Bennett - 16 Sep 2004 13:53 GMT

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...

> I have tried this but I get an error message of
> "too few fields" even though the text file is huge.
[quoted text clipped - 22 lines]
> >
> >.

Reply to this Message