Unexpected Text Changes Using HTML as Data Source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger Bunch - 17 Nov 2006 13:21 GMT

I am using Word 2002 with SP3 and have a Customer ID alphanumeric merged
field which is populated using HTML as the data source. This field works fine
with one exception. If the next to the last character is the letter D then I
get strange results. For example, 309181618D1 becomes 3091816180, 309181618D4
becomes 3091816180000, 309181618D8 becomes 309181618E+16, etc. Changing the
Customer ID is not an option. Any suggestions?

Reply to this Message

Peter Jamieson - 17 Nov 2006 14:45 GMT

Weird. This can happen if Word 2002/3 uses OLEDB to open the HTML file. If
it is doing that, you will probably have to pick a table from a list when
you try to connect to the data source.

However OLEDB isn't Word's default method for connecting to HTML files, so
I'd have to guess that you also have Word Tools|Options|General|"Confirm
conversion at open" checked and are choosing the OLEDB option.

Either way, ensure that option is checked, select either of the options that
doesn't say "OLEDB", and the problem should disappear.

(FWIW I don't know why the OLEDB HTML provider (which is part of the
Access/Jet database engine) interprets the value in this way, but perhaps
there's a good reason)

Peter Jamieson

>I am using Word 2002 with SP3 and have a Customer ID alphanumeric merged
> field which is populated using HTML as the data source. This field works
[quoted text clipped - 6 lines]
> the
> Customer ID is not an option. Any suggestions?

Reply to this Message

Roger Bunch - 20 Nov 2006 12:32 GMT

That seems to have been it. Thanks.

> Weird. This can happen if Word 2002/3 uses OLEDB to open the HTML file. If
> it is doing that, you will probably have to pick a table from a list when
[quoted text clipped - 23 lines]
> > the
> > Customer ID is not an option. Any suggestions?

Reply to this Message