Which is the best/fastest Mail Merge Data Source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Philip L Jackson - 07 Jul 2006 23:02 GMT

All

For speed which is the best Mail Merge Data Source to use?

Thanks

Reply to this Message

Graham Mayor - 08 Jul 2006 06:19 GMT

Word is happiest with a Word table as data source, but that has limitations
on the number of columns available for fields.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> All
>
> For speed which is the best Mail Merge Data Source to use?
>
> Thanks

Reply to this Message

Philip L Jackson - 08 Jul 2006 09:00 GMT

Thanks for this

I was however primarily interested in datasource such as foxPro, csv files
and other external databases.

sorry I did not make myself clear

Philip L Jackson

> Word is happiest with a Word table as data source, but that has limitations
> on the number of columns available for fields.
[quoted text clipped - 4 lines]
> >
> > Thanks

Reply to this Message

Peter Jamieson - 08 Jul 2006 13:32 GMT

In Word 2002/2003, when you first establish a connection, it can take quite
a long time whatever the data source (from what I have seen I suspect that
this is because of the support for excluding/including individual records).
I /believe/ that connection to OLEDB/ODBC type data sources is probably
fastest. I doubt if it makes much difference what the specific backend is
(FoxPro, Access, SQl Server etc.), as fetching the records is rarely the
slowest link in the chain). Probably the best thing to do is try the same
data loaded into your candidate databases/formats - it doesn't usually take
long to import/export from one DBMS to another.

Peter Jamieson

> Thanks for this
>
[quoted text clipped - 14 lines]
>> >
>> > Thanks

Reply to this Message