mail merge from access to publisher

[malcolmmabe]

does anyone know how to keep a field that has been mail
merged from an access database as currency, as currency.
at the moment, i'm getting results such as 1.2235. these
aren't being stored in access like this, so why is
publisher picking them up like this?

 

[McCabe's Minuteman]

Actually, the raw data IS being stored in Access (Excel, too) like that.
Access applies filters (like currency, and decimal rounding, etc) when
displaying the data. It does not actually modify the stored data.
Unfortunately, publisher imports the raw data without the ability to use
similar filters. This is especially frustrating with dates, and numbers
where leading zeros are important.

 

[Brian Kvalheim - [MS MVP]]

Hi (e-mail address removed) ([email protected]),
in the newsgroups
you posted:

|| does anyone know how to keep a field that has been mail
|| merged from an access database as currency, as currency.
|| at the moment, i'm getting results such as 1.2235. these
|| aren't being stored in access like this, so why is
|| publisher picking them up like this?

Export your data as *.csv from Access and see if that addresses your issue.

--
Brian Kvalheim
Microsoft Office Publisher MVP
Official Publisher MVP Site:
http://www.kvalheim.org

This posting is provided "AS IS" with no warranties, and
confers no rights.

 

[Guest]

Interesting question as I have just asked the same in the
excel group - Word has a filter Tools-Options-general -
confirm conversion at opening (thanks to tj) Publisher
does not. I have tried the csv option with no success.
I am a teacher with gcse students and this is one of the
tasks (aqa - plant labels) 15 in excel goes to 14.99999
in publisher. did not happen in the old version!
Any help please?