Which is the best/fastest Mail Merge Data Source

[Philip L Jackson]

All

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

Thanks

 

[Graham Mayor]

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

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Philip L Jackson]

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

 

[Peter Jamieson]

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