Length of string that can be merged from Excel and Access

[Robert Marks]

When merging comments from an Excel spreadsheet (also happens with same
comments in Access database) noticed that the longer strings were being cut
off in mid word. I would guess there is a limit to the length of the string
that can be merged? Is it 255 characters or what? Got around the problem
by pasting relevant part of the spreadsheet into a Word document and merged
from there.

Is there any way to solve this one without having to paste into Word?

Another issue is when spreadsheet contains a "mixture" of strings and
numbers. There was no problem with the merge "per se" - no error message
etc, but only the numbers were merged - the strings were simply " ignored"
as far as I can see. The same data transferred into Access or a table in
Word merged both. Tried to fool it by putting a "dummy" row of string data
at the top of the block of Excel I wanted to merge but it still merged only
the numbers. Any ideas?

Robert B. Marks

 

[Cindy M -WordMVP-]

Hi Robert,

When merging comments from an Excel spreadsheet (also happens with same
comments in Access database) noticed that the longer strings were being cut
off in mid word. I would guess there is a limit to the length of the string
that can be merged? Is it 255 characters or what?
Yep.

Is there any way to solve this one without having to paste into Word?

You need to connect using a different method, probably. Version of Word?

Another issue is when spreadsheet contains a "mixture" of strings and
numbers. There was no problem with the merge "per se" - no error message
etc, but only the numbers were merged - the strings were simply " ignored"
as far as I can see.

Again, version of Word?

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