If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Header Record Delimiter (comma does not work)
Office 2007 Word. Mail Merge. Select Recipients. Use Existing List. Select
Data Source. path.txt. The comma selection does not work. When selected, the error message "Record n contained too many data fields" .. appears The .txt file is fine and works fine when imported as a text file into Excel. Any fixes out there? TIA Dan |
#2
|
|||
|
|||
Header Record Delimiter (comma does not work)
1. Let's assume you do not have unquoted fields that contain commas.
2. if you create a coma-deleimited test file with (say) two columns, a header row and two data rows, does that work? 3. Not sure the following make any difference, but... a. which delimiter dialog are you seeing? Are you seeing the one that asks for field and record delimiter, and shows a number of options for each, or the (OLE DB) dialog that lets you choose a field delimiter which can be comma, tab or other? b. Is comma set to be the decimal point character in Regional Settings on your system? Peter Jamieson http://tips.pjmsn.me.uk Dan Meigs wrote: Office 2007 Word. Mail Merge. Select Recipients. Use Existing List. Select Data Source. path.txt. The comma selection does not work. When selected, the error message "Record n contained too many data fields" .. appears The .txt file is fine and works fine when imported as a text file into Excel. Any fixes out there? TIA Dan |
Thread Tools | |
Display Modes | |
|
|