Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2002 and Excell 2002 merge issues
I am running Word 02 and Excel 02. I am using the two to perform a merge for
a basketball program book. I am getting errors when I try to connect to the spreadsheet. After I select the spreadsheet (saved in .xls format) a box opens to "select a table". There is nothing in the box to select. The options button shows that I have selected a table, and the drop down box shows files I have used previously. I have created a work around, saving the file in a text format. I can merge, until I reach record 16. "Record 16 contained too few fields" is the message. This record has the same number of fields as 1-15 did. That message continues up to record 32. Each record may not have every field filled in, but they have the same number of possible fields. Thank you for your assistance. Jim Kroll |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2002 and Excell 2002 merge issues
When Word 2002 uses an Excel worksheet as a data source, it tries various
different ways of connecting to the worksheet. First it tries "OLEDB". if it can't connect using that (and there are various possible reasons why) it usually pops up a "data link dialog box". But you don't seem to be seeing that. If OLEDB didn't work, it tries "ODBC". The dialog you describe is the ODBC dialog, and you have to try to make sure that your database is the one selected from the drop-down (because it may not be selected at this point). Unfortunately that's not easy because you usually cna't see the full pathname in that little box. I sometimes move files into afolder such as c:\a for test purposes so I can see what's going on. In the ODBC dialog box, you generally don't see anything until you click the Options... button - then just select all the checkboxes and your worksheets should then appear in the list. If ODBC didn't work, it tries DDE. You would see yet another dialog box with "Entire spreadsheet" in one of the text boxes if you got that far. Chances are that the reason Word isn't succeeding with OLEDB is that the workbook is already open in Excel (close it) or is corrupt. If it's corrupt and not complex (for example, just has tabular data and no formulas) you can try exporting each sheet to a .csv format then reconstructing the workbook by re-importing them. I can merge, until I reach record 16. "Record 16 contained too few fields" is the message. This record has the same number of fields as 1-15 did. That message continues up to record 32. Each record may not have every field filled in, but they have the same number of possible fields. The chances are that record 15 or 16 has a field containing a double-quote character " (e.g. you might have someone's height in inches in there). As a workaround, you may be able to wrap that field in double-quotes if it isn't already, and double up the double-quote. Or there may be some other "unusual" character in there such as a carriage return. If you can't get Word to connect to Excel and you don't have more than 63 columns in your worksheet, you could try copying/pasting your worksheet into a blank Word document instead, and use that as the data source. Peter Jamieson "JWKroll" wrote in message ... I am running Word 02 and Excel 02. I am using the two to perform a merge for a basketball program book. I am getting errors when I try to connect to the spreadsheet. After I select the spreadsheet (saved in .xls format) a box opens to "select a table". There is nothing in the box to select. The options button shows that I have selected a table, and the drop down box shows files I have used previously. I have created a work around, saving the file in a text format. I can merge, until I reach record 16. "Record 16 contained too few fields" is the message. This record has the same number of fields as 1-15 did. That message continues up to record 32. Each record may not have every field filled in, but they have the same number of possible fields. Thank you for your assistance. Jim Kroll |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2002 and Excell 2002 merge issues
I saved the file in the .csv format. I then tried to connect this file to my
Word document. The merge starts, but at record 16 I am getting the message that states there are too few data fields. This message continues from 16 - 32. Finally, the merge is complete (and correct.) "Peter Jamieson" wrote: When Word 2002 uses an Excel worksheet as a data source, it tries various different ways of connecting to the worksheet. First it tries "OLEDB". if it can't connect using that (and there are various possible reasons why) it usually pops up a "data link dialog box". But you don't seem to be seeing that. If OLEDB didn't work, it tries "ODBC". The dialog you describe is the ODBC dialog, and you have to try to make sure that your database is the one selected from the drop-down (because it may not be selected at this point). Unfortunately that's not easy because you usually cna't see the full pathname in that little box. I sometimes move files into afolder such as c:\a for test purposes so I can see what's going on. In the ODBC dialog box, you generally don't see anything until you click the Options... button - then just select all the checkboxes and your worksheets should then appear in the list. If ODBC didn't work, it tries DDE. You would see yet another dialog box with "Entire spreadsheet" in one of the text boxes if you got that far. Chances are that the reason Word isn't succeeding with OLEDB is that the workbook is already open in Excel (close it) or is corrupt. If it's corrupt and not complex (for example, just has tabular data and no formulas) you can try exporting each sheet to a .csv format then reconstructing the workbook by re-importing them. I can merge, until I reach record 16. "Record 16 contained too few fields" is the message. This record has the same number of fields as 1-15 did. That message continues up to record 32. Each record may not have every field filled in, but they have the same number of possible fields. The chances are that record 15 or 16 has a field containing a double-quote character " (e.g. you might have someone's height in inches in there). As a workaround, you may be able to wrap that field in double-quotes if it isn't already, and double up the double-quote. Or there may be some other "unusual" character in there such as a carriage return. If you can't get Word to connect to Excel and you don't have more than 63 columns in your worksheet, you could try copying/pasting your worksheet into a blank Word document instead, and use that as the data source. Peter Jamieson "JWKroll" wrote in message ... I am running Word 02 and Excel 02. I am using the two to perform a merge for a basketball program book. I am getting errors when I try to connect to the spreadsheet. After I select the spreadsheet (saved in .xls format) a box opens to "select a table". There is nothing in the box to select. The options button shows that I have selected a table, and the drop down box shows files I have used previously. I have created a work around, saving the file in a text format. I can merge, until I reach record 16. "Record 16 contained too few fields" is the message. This record has the same number of fields as 1-15 did. That message continues up to record 32. Each record may not have every field filled in, but they have the same number of possible fields. Thank you for your assistance. Jim Kroll |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2002 and Excell 2002 merge issues
Did you have a look at this bit?...
I can merge, until I reach record 16. "Record 16 contained too few fields" is the message. This record has the same number of fields as 1-15 did. That message continues up to record 32. Each record may not have every field filled in, but they have the same number of possible fields. The chances are that record 15 or 16 has a field containing a double-quote character " (e.g. you might have someone's height in inches in there). As a workaround, you may be able to wrap that field in double-quotes if it isn't already, and double up the double-quote. Or there may be some other "unusual" character in there such as a carriage return. If you want, despam my email address (delete "killmaps"), send me the .csv file, and I'll have a look. Peter Jamieson "JWKroll" wrote in message news I saved the file in the .csv format. I then tried to connect this file to my Word document. The merge starts, but at record 16 I am getting the message that states there are too few data fields. This message continues from 16 - 32. Finally, the merge is complete (and correct.) "Peter Jamieson" wrote: When Word 2002 uses an Excel worksheet as a data source, it tries various different ways of connecting to the worksheet. First it tries "OLEDB". if it can't connect using that (and there are various possible reasons why) it usually pops up a "data link dialog box". But you don't seem to be seeing that. If OLEDB didn't work, it tries "ODBC". The dialog you describe is the ODBC dialog, and you have to try to make sure that your database is the one selected from the drop-down (because it may not be selected at this point). Unfortunately that's not easy because you usually cna't see the full pathname in that little box. I sometimes move files into afolder such as c:\a for test purposes so I can see what's going on. In the ODBC dialog box, you generally don't see anything until you click the Options... button - then just select all the checkboxes and your worksheets should then appear in the list. If ODBC didn't work, it tries DDE. You would see yet another dialog box with "Entire spreadsheet" in one of the text boxes if you got that far. Chances are that the reason Word isn't succeeding with OLEDB is that the workbook is already open in Excel (close it) or is corrupt. If it's corrupt and not complex (for example, just has tabular data and no formulas) you can try exporting each sheet to a .csv format then reconstructing the workbook by re-importing them. I can merge, until I reach record 16. "Record 16 contained too few fields" is the message. This record has the same number of fields as 1-15 did. That message continues up to record 32. Each record may not have every field filled in, but they have the same number of possible fields. The chances are that record 15 or 16 has a field containing a double-quote character " (e.g. you might have someone's height in inches in there). As a workaround, you may be able to wrap that field in double-quotes if it isn't already, and double up the double-quote. Or there may be some other "unusual" character in there such as a carriage return. If you can't get Word to connect to Excel and you don't have more than 63 columns in your worksheet, you could try copying/pasting your worksheet into a blank Word document instead, and use that as the data source. Peter Jamieson "JWKroll" wrote in message ... I am running Word 02 and Excel 02. I am using the two to perform a merge for a basketball program book. I am getting errors when I try to connect to the spreadsheet. After I select the spreadsheet (saved in .xls format) a box opens to "select a table". There is nothing in the box to select. The options button shows that I have selected a table, and the drop down box shows files I have used previously. I have created a work around, saving the file in a text format. I can merge, until I reach record 16. "Record 16 contained too few fields" is the message. This record has the same number of fields as 1-15 did. That message continues up to record 32. Each record may not have every field filled in, but they have the same number of possible fields. Thank you for your assistance. Jim Kroll |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why i can't insert excell wokbook in a Word document | Microsoft Word Help |