Word Merges via ODBC

[frustrated QA]

When I try to connect to an ODBC data source to do a Word merge I get an
error. It is often "Record 1 contains too few data fields" popping up
several times, although the error varries depending on how I try to connect.

This is using Office XP, Office 2000 works fine.

It happens with most ODBC sources but cvs works fine.

Does anyone have any suggestions?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?ZnJ1c3RyYXRlZCBRQQ==?=,

What is the ODBC data source? And what ODBC driver are you selecting?

When I try to connect to an ODBC data source to do a Word merge I get an
error. It is often "Record 1 contains too few data fields" popping up
several times, although the error varries depending on how I try to connect.

This is using Office XP, Office 2000 works fine.

It happens with most ODBC sources but cvs works fine.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[frustrated QA]

Hi Cindy,

I have tried a SQL ODBC source, Dbase, and Oracle as ODBC sources. The ODBC
drivers I'm using are from the Oracle 9 Client, Visigenic 5.1 (comes with
Interbase), and the SQL driver I assume comes with Windows. (I have XP SP2)

 

[Sheri]

Hi I have a similar problem.

If I select a data source from My Data Sources, specifically created for the
exact SQL table in questions, Word gives me a a datalink properties box.
Entering my specific User name and Password, vs NT Intregrated, the Test
Connection succeeds , then when I click "OK" I get an error saying Word can
not open data source. If I cancle before the OK, I get the Too Few Peramater
message noted above.

Any help would be fantastic!! Thanks,

Sheri