Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2006

Tip: Looking for answers? Try searching our database.

Merging needing too many fields for excel and access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Nikki - 07 Aug 2006 23:18 GMT
Hi,

I have a document that I need to create that merges the data from excel or
access into word.  both Excel and Access limit me to 255 rows/columns and I
need more than this.  Is there a way to be able to merge more than 255?

Nikki
Peter Jamieson - 08 Aug 2006 03:58 GMT
Many things, even "heavyweight" server databases such as SQL Server, will
limit you to 255, 127 or 63 columns.

Earlier versions of Word (say, 2000 and earlier) could quite happliy deal
with tab- or comma-delimted text files with thousands of fields. However, it
is touch and go in Word 2002/2003 whether they will work. This is probably
because Word 2002/2003 try to deal with international character encoding
issues, and try to determine what character set is being used, and sometimes
size alone appears to cause them to make a mistake.

You can /try/ putting your data in a delimited format (typically
comma-delimited or tab-delimited) in either a plain text file or a Word
document. If you use a plain text file, you may need to check Word
Tools|Options|General|"Confirm conversions at open", then make sure you
select the "Text files (*.txt)" option when offered. But
a. there is no guarantee it will work
b. you will definitely need to avoid using the delimiter character (e.g.
"," or tab) in your data fields, or ensure that fields are enclosed in
double-quotes if you do, and that double quotes within the data are doubled
up. e.g. if you had three fields a,b,c with data as follows

a: abcd
b: e,"f
c: ghij

you should try using the following layout

a,b,c
"abcd","e,""f","ghij"

Peter Jamieson

> Hi,
>
[quoted text clipped - 4 lines]
>
> Nikki

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.