Access database to merge with a Word document.

[Nigel]

The error is when I try to use an Access database to
merge with a Word document.

There are a number of dates set up in UK long date format
in the database table, ie: 06 April
2004.

When I merge this data into Word, the days and dates
get 'mixed' up because it converts them back
into US format AND it also reads the days as months, and
vice versa.

I have tried applying various switches to the date field
in Word, but this doesn't work for the
reason above, and the dates appear in a strange format,
eg: 04 0006 04 and things like that.

I have half-solved the problem by inputting the dates
again, in text format on the Access database
so they don't change during the merge process, but this
isn't ideal because the dates now are in the
wrong order, eg: 19th April comes before 6th April and so
on. This also very tedious as I have
about 600 records in the table! I could convert the
database table into .rtf format as the data
source, but this means that the data does not get updated
and I would have to do this everytime I make a change to
the original table.

By the way, the error actually occurs BEFORE any data is
merged, ie: when you select the data
source and preview it, the dates are wrong.

Thanks
Nigel

 

[Doug Robbins - Word MVP]

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.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