A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I save an access document in word document?



 
 
Thread Tools Display Modes
  #1  
Old September 13th, 2005, 10:37 PM
cmartin
external usenet poster
 
Posts: n/a
Default How do I save an access document in word document?


  #2  
Old September 13th, 2005, 11:10 PM
Ron Hinds
external usenet poster
 
Posts: n/a
Default

I think what you really want to do is import access data into a word
document, correct? I just typed in "import access data" in the help pane in
Word 2003 and it gives explicit directions:

Insert data from Access or other data source
Show All
Hide All
You can use a query (query: A question about the data stored in your
tables, or a request to perform an action on the data. A query can bring
together data from multiple tables to serve as the source of data for a
form, report, or data access page.) to import data from a Microsoft Access
database or other data source. You can also use queries to sort and filter
your data during the import process.

To keep the data in your document up to date, you can create a link to
the data source. Whenever the data is changed in the source file, Microsoft
Word can automatically update it in your Word document.

Insert information into an existing document

1.. In the Word document, click where you want to insert the
contents of the table or query.
2.. Display the Database toolbar (toolbar: A bar with buttons and
options that you use to carry out commands. To display a toolbar, click
Customize on the Tools menu, and then click the Toolbars tab.), and then
click Insert Database .
3.. Click Get Data.
4.. Choose how to retrieve, filter, and sort the data by doing one
of the following:
Browse for the file

1.. In the Look in box, click the location of the data source you
want to use.
2.. In the Files of type box, click the type of data source you
want to use. If you know the file name but not the file type, select All
Data Sources.
3.. Click the data source file, and then click Open.
4.. In the Select Table dialog box, if available, click the table
or query you want, and then click OK.
5.. To choose a subset of the records or fields or both to include
in the Word table, click Query Options, and then select the criteria you
want.
How?

To select specific data records (data record: A complete set of
related information that corresponds to one row of information in the data
source. All information about one client in a client mailing list is an
example of a data record.) to merge, you can choose selection criteria (or
"rules") on the Filter Records tab in the Query Options dialog box. For each
rule, you need to specify:

a.. A data field (data field: A category of information that
corresponds to one column of information in a data source. The name of each
data field is listed in the first row (header row) of the data source.
"PostalCode" and "LastName" are examples of data field names.) in the
selected data source.
b.. A comparison phrase such as Equal to or Is not blank.
c.. Text or numbers that you want to compare with the contents
of the data field.
For example, to select only the data records of Seattle customers,
specify the City data field, use the comparison phrase Equal to, and type
the text Seattle.

6.. Click OK.
Use Microsoft Query

1.. On the Tools menu in the Select Data Source dialog box, click
MS Query.
2.. Construct your query.
Note If you want help with Microsoft Query, close the Choose Data
Source dialog box, and then click Microsoft Query Help on the Help menu.

Use the Data Connection Wizard

Use the Data Connection Wizard to connect to databases on computers
that are running Microsoft SQL Server and other database management systems.
You can also use the Data Connection Wizard when you need to choose a
specific database driver or ODBC data source name (DSN).
1.. In the Select Data Source dialog box, click New Source, and
follow the directions in the Data Connection Wizard.
2.. Click the data source in the Select Data Source dialog box,
and then click Open.
3.. To choose a subset of the records or fields or both to include
in the Word table, click Query Options, and then select the criteria you
want.
How?

To select specific data records (data record: A complete set of
related information that corresponds to one row of information in the data
source. All information about one client in a client mailing list is an
example of a data record.) to merge, you can choose selection criteria (or
"rules") on the Filter Records tab in theQuery Options dialog box. For each
rule, you need to specify:

a.. A data field (data field: A category of information that
corresponds to one column of information in a data source. The name of each
data field is listed in the first row (header row) of the data source.
"PostalCode" and "LastName" are examples of data field names.) in the
selected data source.
b.. A comparison phrase such as Equal to or Is not blank.
c.. Text or numbers that you want to compare with the contents
of the data field.
For example, to select only the data records of Seattle customers,
specify the City data field, use the comparison phrase Equal to, and type
the text Seattle.

4.. Click OK.

5.. To customize the Word table formatting, click Table AutoFormat,
select the options you want, and then click OK.
6.. Click Insert Data.
7.. Under Insert Records, select the records to include in the Word
table.
8.. If you want to be able to update the data in the Word table when
the source data changes, select the Insert data as field check box.
Word inserts the data in the Word table as a DATABASE field (field:
A set of codes that instructs Microsoft Word to insert text, graphics, page
numbers, and other material into a document automatically. For example, the
DATE field inserts the current date.), which is linked to the source table
or query. To update the field, click in the table and press F9.

Export Access data into a new document

To transfer Access data to a new Word document, export an Access
table, query, report, or other database object. Then you can use Word to
format and edit the data, or you can use the data as a mail merge data
source.

1.. In Access, open the database you want, and then open a database
object: either a table, query, form, or report.
2.. To export part of the data only, select the rows or columns you
want.
3.. On the File menu, click Export.
4.. In the Save as type box, choose a file format for the exported
data:
a.. To create a document that preserves the data's original
formatting, click Rich Text Format.

a.. To create a plain text file for use as a mail merge data
source, click Microsoft Word Merge.

5.. In the File name box, specify a file name for the new document.
6.. To export the entire database object, click Export All.
Export All is not available unless a you open database object, such
as a table or query.

If you chose Text Files, you can export selected specific rows or
columns in the data. Click the arrow next to Export All ,and then click Save
Selection



"cmartin" wrote in message
...











Attached Images
File Type: gif bluedrop.gif (176 Bytes, 94 views)
  #3  
Old September 13th, 2005, 11:26 PM
John Vinson
external usenet poster
 
Posts: n/a
Default

On Tue, 13 Sep 2005 14:37:23 -0700, "cmartin"
wrote:


Since there is no such thing as an "Access Document", your question as
asked has no answer.

Could you please explain, preferably in the text area of the message
rather than just in the subject line? Are you trying to export an
Access Report to Word? If so, open the Report in preview mode, and use
File... Export; select .rtf as the type of file to export.

John W. Vinson[MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
The WordPerfect "Reveal Codes" method is so much easier to use. Torden General Discussion 6 April 19th, 2010 07:50 PM
Can't Open Data Source (Query) where criteria is defined by functi l_stocky Mailmerge 7 January 22nd, 2005 05:09 AM
How do I create & merge specific data base & master documents? maggiev New Users 2 January 12th, 2005 11:30 PM
WP Delay Code - Word Equiv Mike G - Milw, WI General Discussion 6 January 10th, 2005 04:12 PM
Continuous breaks convert to next page breaks Jennifer Hunt General Discussion 2 December 30th, 2004 05:45 PM


All times are GMT +1. The time now is 01:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.