Re: Access to Word Mail Merge; symbols change to question marks

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Peter Jamieson (pjj_at_KillmapSpjjnet.demon.co.uk)
Date: 01/17/05 

Date: Mon, 17 Jan 2005 12:25:54 -0000

My guess is that you are using Word 2000 or earlier, since this should work
in Word 2002 or 2003 as long as Word is connecting to Access using OLEDB.

As far as I know, there is no way to get these characters through in Word
2000 - neither of the
connection methods supported in Word 2000 (DDE and ODBC) lets them
through, despite the fact that both applications are
Unicode-enabled in other areas. What probably will work is the following:
 a. open the table (or query results) you are using as your data source in
Access, in the plain "spreadsheet view"
 b. Select the entire table (click on the top left corner
 c. Edit|Copy
 d. Open a new blank Word document
 e. Edit|Paste (or if there are more than the maximum number of columns,
Edit|Paste Special and use "Unformatted Unicode text"
 f. close the Word document and use it as your data source for the merge.

Peter Jamieson

"Rob S." <RobS@discussions.microsoft.com> wrote in message
news:882BEC0E-19BA-40E0-B3A4-50FEF0EBC3DE@microsoft.com...
> Hello,
>
> I have an access database in which I store a bunch of science terms and
> definitons. Increasingly, I find that my definitions require symbols (ex:
> delta, gamma, sigma, etc. I merge the database with Word to make
> flashcards.
>
> Note:
> (1) I've been using Arial font.
> (2) When inputting the symbols, I don't just change that character to the
> "symbol font." I use the character map.
>
> The Problem: When I merge the database to Word, the characters appear as
> question marks.
>
> Could anyone tell me if there is a solution out there?
>
> Thanks

Relevant Pages

  • Re: MySQL text field lengths truncated
    ... connecting to a remote MySQL server 4.1.10. ... I've got a text field in a table in the database. ... I get 255 characters in the field. ... How are you accessing the MySQL server? ...
    (borland.public.delphi.database.ado)
  • Re: Loading a data file containing character fields with different encodings
    ... The data is coming from one database that contains UTF-8 characters and it appears that he's attempting to load ... UTF-8 characters along with Latin-1 characters. ... it would be just as easy to write the loader script that converts the encoding to a "unicode" intermediate format and then load with the correct database encoding. ...
    (comp.databases.informix)
  • Re: Loading a data file containing character fields with different encodings
    ... The data is coming from one database that contains UTF-8 characters and it appears that he's attempting to load ... UTF-8 characters along with Latin-1 characters. ... it would be just as easy to write the loader script that converts the encoding to a "unicode" intermediate format and then load with the correct database encoding. ...
    (comp.databases.informix)
  • Re: Connect to Access Data from various regional locations
    ... All users will be connecting via broadband. ... When using MSDE ... > Dim rf As DAO.Recordset ... > There is a wizard to split your database into a FE and a BE; ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Connect to Access Data from various regional locations
    ... All users will be connecting via broadband. ... When using MSDE ... > Dim rf As DAO.Recordset ... > There is a wizard to split your database into a FE and a BE; ...
    (microsoft.public.access.externaldata)