How to Retain Formatting When Exporting MS Access Data
  
PSS ID Number: Q110235
Article last modified on 11-01-1994
 
2.00 2.00a 2.00a-CD 2.00b 2.00c
 
WINDOWS
 

-------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Word for Windows, versions 2.0, 2.0a, 2.0a-CD, 2.0b,
   2.0c
 - Microsoft Access for Windows, version 1.0
 - Microsoft Windows operating system versions 3.0 and 3.1
-------------------------------------------------------------------
 
When you export data, Microsoft Access for Windows writes raw, unformatted
data. Use one of the following methods if you want to include formatted
Microsoft Access data in your Word for Windows document:
 
1. In Microsoft Access, close the table/query and copy it to the Windows
   Clipboard. Then paste it into Word and save the data document.
 
2. Write a MakeTable query that uses the FORMAT() function to specifically
   format each field. Run the query and then export the resulting table.
 
3. Write a Select query that uses the FORMAT() function to specifically
   format each field. Use the TransferText macro to export the query.
 
For more information on the above Microsoft Access procedures, see your
Microsoft Access documentation.
 
KBCategory: kbinterop
KBSubCategory:
Additional reference words: 1.00 2.00 2.00a 2.00a-CD 2.00b 2.00c conv
interopsum w_winword b_waccess
=============================================================================
Copyright Microsoft Corporation 1994.