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 / September 2006

Tip: Looking for answers? Try searching our database.

Missing one data from one column from Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
swimdad16 - 06 Sep 2006 22:20 GMT
I am running Office 2003. I export a CSV file from an application. I then
save the CSV as an Excel file, XLS, that is used as input into a Mail Merge.

One of the columns, and numeric field that represents the students school
grade, does not show up in word.

If I look at Merge Recipients I see the column but there are no values in
the field.

What would cause Word to ignore that field?
Peter Jamieson - 07 Sep 2006 08:21 GMT
> What would cause Word to ignore that field?

Don't know, but...

Assuming there isn't somethig weird about the column name, It's possible
that the OLEDB provider/ODBC driver that Word uses to get the data has got
mixed up about the type of data in the column, but a quick experiements here
suggests that's unlikely. A few questions:
a. what format does Excel think the cells have (General?). Does it display
any little warning triangles in the corners of the cells?
b. How is the .csv formatted? e.g. is it actually comma-delimited, or is
another character used? Are the values quoted, e.g. using "". Do the numbers
have "thousands separators," e.g. like "123,456.78". If so, what are they,
and what character is used for the decimal point (i.e. are they like
123,456.78, 123.456,78 or what? - and what do your system settings expect?
c. as possible workarounds...
 - try using the .csv directly as a data source
 - open the .csv in Word, save as .doc, and use that
 - change the connection method to the Excel sheet and/or .csv (Word
Tools|Options|General|"Confirm conversions at open, then reconnect tot he
source and select the method in the additional dialog box)

Peter Jamieson

>I am running Office 2003. I export a CSV file from an application. I then
>save the CSV as an Excel file, XLS, that is used as input into a Mail
[quoted text clipped - 7 lines]
>
> What would cause Word to ignore that field?
swimdad16 - 07 Sep 2006 14:33 GMT
I searched the web again last night and found a website that described the
problem. I don't recall the name right now.

Based on that website it was related to the ODBC/OLE connection between
Excel and Word. Evidently, Word looks at the first 8 line of the excel file
to set the type for the column. Even though I tried to format it as a
number, text and general in Excel, Word comes up with it's own format based
on what it sees in the first 8 rows.

Since many of my entries were blank Word somehow ignored the rows that had
numbers.

I fixed the problem by changing all the blanks cells into zeroes... now it
works as expected.

Thanks for taking the time to respond.

>> What would cause Word to ignore that field?
>
[quoted text clipped - 32 lines]
>>
>> What would cause Word to ignore that field?
 
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.