excel to word using OBDC

[Caryn P]

I have been trying to create form letters using Word 2000 and Excel 2000 as my datasource. I need to be able to use multiple worksheets and also to be able to specify ranges of cells, so I am using the OBDC option when selecting my datasource. I have gone through the process several times, and everything works properly except for the zip field. Sometimes it does not acknowledge the zip field at all and just stops after the state. Other times, the zips are formatted as "60016.0". I have doublechecked the formatting in Excel, specifying it as both "special- zip" and as "text." Neither seems to work. I do have both 5 digit and 5+4 zips in the various sheets. Can anyone help?

 

[Doug Robbins - Word MVP]

Hi Caryn,

See the US Zip Codes item on fellow MVP Graham Mayor's website at
http://www.gmayor.dsl.pipex.com/formatting_word_fields.htm

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

I have been trying to create form letters using Word 2000 and Excel 2000

as my datasource. I need to be able to use multiple worksheets and also to
be able to specify ranges of cells, so I am using the OBDC option when
selecting my datasource. I have gone through the process several times, and
everything works properly except for the zip field. Sometimes it does not
acknowledge the zip field at all and just stops after the state. Other
times, the zips are formatted as "60016.0". I have doublechecked the
formatting in Excel, specifying it as both "special- zip" and as "text."
Neither seems to work. I do have both 5 digit and 5+4 zips in the various
sheets. Can anyone help?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?Q2FyeW4gUA==?=,

<<I have been trying to create form letters using Word 2000 and Excel 2000 as
my datasource. I need to be able to use multiple worksheets and also to be
able to specify ranges of cells, so I am using the OBDC option when selecting
my datasource. I have gone through the process several times, and everything
works properly except for the zip field. Sometimes it does not acknowledge the
zip field at all and just stops after the state. Other times, the zips are
formatted as "60016.0". I have doublechecked the formatting in Excel,
specifying it as both "special- zip" and as "text." Neither seems to work.>>

The ODBC driver won't recogniz "text" set in the Format/Cell dialog box.
Instead, you need to select the column, then use the "Text to Columns" command
in Excel's Data menu.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail