Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Run out of columns
Office 2003 sp2 - Windows pro sp2
I am using word to merge data from an excel sheet - but I have run out of columns in excel I assume you can not add any more ! So can I get word to merge from sheet 1 and then continue on sheet 2 ? I thought a csv file of the data would not have a column limit, but how do I get excel to save a csv file of two sheets together Many thanks for any ideas or suggestions pete |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Run out of columns
As far as I know the current limit in Excel is 256 columns.
Most other data sources have a limited which is imposed either by the data source (e.g. Access has a 255 column limit) or by the method used to connect to it (typically OLEDB or ODBC) If you create a .csv with more than around 255 columns, and try to open that as a data source in Word 2003, the open will probably succeed, but you will find that Word only reads around 255 of the columns at most. That is probably because by default it uses OLEDB to open such a file. If you check Word Tools|Options|COnfirm conversion at open, then try connecting again (start with a fresh document), you should see an additional dialog box titled "Confirm Data Source". Check the Show All box, and select Text Files (*.*). You may then see an encoding dialog, which may well choose the wrong encoding (typically it should be Windows, but UTF-8 might work OK for you too - I don't know. You might be able to avoid some of that process by giving the file a .txt extension instead. Then you /might/ see a lot more columns, and possibly even all of them. However, I do not do this regularly and according to reports it may be that what you see depends on the number of columns and size and complexity of the data. To get the stuff out of Excel into a single .csv I think you will probably have to write some Excel VBA code, or maybe you could create a new column which used the Excel CONCAT function to concatenate all the columns into a single new text column and export that (not something I'd particularly want to get right!). But I don't know Excel that well and you would be better off asking that question in an Excel group. Peter Jamieson "Pete" wrote in message ... Office 2003 sp2 - Windows pro sp2 I am using word to merge data from an excel sheet - but I have run out of columns in excel I assume you can not add any more ! So can I get word to merge from sheet 1 and then continue on sheet 2 ? I thought a csv file of the data would not have a column limit, but how do I get excel to save a csv file of two sheets together Many thanks for any ideas or suggestions pete |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Columns for Separate Statement on Motn for Summary Judgment | Microsoft Word Help | |||
How do I hide table columns with text in them, in Word 2000 | Tables | |||
Table Sort - Sort only 3 of 4 columns | Microsoft Word Help | |||
Word columns | Microsoft Word Help | |||
How to create multiple pages with newpaper columns | Page Layout |