max # cols in XL data source?

[Ann Scharpf]

I am trying to do a mail merge with an Excel file as a
data source. I'm running Office 2000.

I have 176 columns in the data source and when I try to
link the data source to the form, I get an error message
that says, "Word was unable to open the data source."

Is there a limit to the number of cols I can have in the
data source? Is there any way around this? Is Access
more flexible as a data source?

Thanks for any help you can give me.

Ann Scharpf

 

[Sandy]

If you open the Excel file independently from Word, it might tell you the reason it couldn't open file

I recently saw that error however it didn't have to do with the number of columns being too large to open the file.

 

[Cindy M -WordMVP-]

Hi Ann,

In addition to the "anonymous" answer you got:

Do you know which connection method you're using? If not,
it's probably DDE; ODBC might give you more flexibility.

Activate the "Select method" checkbox in "Open data
source". Choose ODBC from the list that should appear.

I am trying to do a mail merge with an Excel file as a
data source. I'm running Office 2000.

I have 176 columns in the data source and when I try to
link the data source to the form, I get an error message
that says, "Word was unable to open the data source."

Is there a limit to the number of cols I can have in the
data source? Is there any way around this? Is Access
more flexible as a data source?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.mvps.org/word

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