Thread Tools Display Modes
  #1   Report Post  
Posts: n/a
Default how do you create a data source

how do i create a data source
  #2   Report Post  
Peter Jamieson
Posts: n/a

There are lots of different ways, but the exact details depend on which
version of Word you are using. Broadly speaking, you can either:
a. use the facilities provided in the Mail Merge Helper in Word 97 or
2000 - click the Get Data button, and use the Create Data Source option.
When Word prompts you to save the data, you can choose a number of formats,
e.g. text file, Word document and so on.
b. use the facilities provided by the Mail Merge Wizard in Word 2002 or
2003. In the case, Word creates a special kind of Jet (Access) database
(.mdb) called an Office Address List.

If you want to create a data source outside Word, lots of different formats
can be used, e.g.
a. comma-delimited text files with a header row containing column names
b. an Excel spreadsheet with one row per record and a header row containing
column names
c. Access tables and Queries (with some exceptions)
d. A Word document containing a table with one row per record and a header
row containing column names
e. tables in databases such as SQL Server or Oracle that can be accessed by
ODBC (or OLEDB, in Word 2002/2003)

Each format has its advantages and disadvantages, e.g. you may have
difficulty if you use (a) and your data contains commas, double-quote
characetrs and so on. If you are familiar with Access, it is worth
considering keeping your data in there, and you may find that its report
function is better for creating the output you need. For small data sources
with fewer than 64 columns I still favour using (d) because you can create
everything you need in Word, and it's easy to create multi-line fields and
use things such as double quotes. However, merging from Word data sources
can be very slow in Word 2002/2003.

Peter Jamieson
"cmcq" wrote in message
how do i create a data source

Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I keep merged data from advancing surrounding text in a fo. Don Coffey Microsoft Word Help 0 December 23rd 04 05:03 PM
How do I set field length in template/form regardless of data siz. shdrjw Microsoft Word Help 2 December 7th 04 09:04 PM
Word 2000 - Table - Create a new row for each record. Jeanne Moos Tables 1 December 2nd 04 12:02 AM
Merge Data Source path Peter Jamieson Mailmerge 0 November 25th 04 08:15 PM
Export table data to Excel Kenny Kepler Tables 1 November 25th 04 02:45 PM

All times are GMT +1. The time now is 07:44 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Word"