Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

How to get Access report into Word


  • Please log in to reply

#1
Hello_Moto

Hello_Moto

    Member

  • Member
  • PipPip
  • 46 posts
Hi folks,

I've been doing a report for college and I want to import into my Word document some of the results of my queries and reports that I have ran in my Access database for this project. How can I do this ?? I've been looking for some kind of 'Import' selecting when I run my query/report but can't seem to find it or a way around this.

Is this possible ? And if so, how can it be achieved ??

Thanks in advance.

H_M
  • 0

Advertisements


#2
Retired Tech

Retired Tech

    Retired Staff

  • Retired Staff
  • 20,563 posts
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.

In Access, open the database you want, and then open a database object: either a table, query, form, or report.

To export part of the data only, select the rows or columns you want.

On the File menu, click Export.

In the Save as type box, choose a file format for the exported data:

To create a document that preserves the data's original formatting, click Rich Text Format.

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

In the File name box, specify a file name for the new document.

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.

OR

In the Word document, click where you want to insert the contents of the table or query.
Display the Database toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.), and then click Insert Database .

Click Get Data.

Choose how to retrieve, filter, and sort the data by doing one of the following:

Browse for the file

In the Look in box, click the location of the data source you want to use.

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.

Click the data source file, and then click Open.

In the Select Table dialog box, if available, click the table or query you want, and then click OK.

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 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.

A comparison phrase such as Equal to or Is not blank.
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.

Click OK.

Use Microsoft Query

On the Tools menu in the Select Data Source dialog box, click MS Query.

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).
In the Select Data Source dialog box, click New Source, and follow the directions in the Data Connection Wizard.

Click the data source in the Select Data Source dialog box, and then click Open.

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 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.

A comparison phrase such as Equal to or Is not blank.
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.

Click OK.

To customize the Word table formatting, click Table AutoFormat, select the options you want, and then click OK.

Click Insert Data.

Under Insert Records, select the records to include in the Word table.

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.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP