OL2000: Truncated Data From Imported dBase File (204937)
The information in this article applies to:
- Microsoft Excel 2000
- Microsoft Outlook 2000
This article was previously published under Q204937 SYMPTOMS
If you save a Microsoft Excel workbook containing a named range, in a
dBase (.dbf) file format and then import the dBase file into Microsoft
Outlook, some of the data may be truncated.
CAUSE
If any cells in your named range are narrower than the width of the data,
that data is truncated because it does not fit within the visual selection
of the named range. When you save the Microsoft Excel file in a dBase
format, the data in those narrow cells is truncated.
RESOLUTION
There are two methods to resolve this problem:
- Do not save the file in dBase format; import the file with the named range as a Microsoft Excel workbook file.
- If you use the dBase file format, make sure all columns are wide enough to accommodate the data before you define the named range.
MORE INFORMATION
When you define a named range in a Microsoft Excel worksheet, the data in
the last column may appear outside of the selected area if the width of the
column is narrower than its data. If you save the workbook as a dBase file
and then import it into Outlook, the data that did not fit within the last
column is truncated. If you use the same procedure, but save the file as an
Microsoft Excel workbook file, the data is not truncated.
REFERENCES
For more information on data lost saving in a dBase format from Microsoft
Excel, please see the following article in the Microsoft Knowledge Base:
46228
XL5: Data Lost When File Saved in .DBF File Format
For more information on Importing from Microsoft Excel into Outlook, please
see the following article in the Microsoft Knowledge Base:
196743
OL2000: Importing from Microsoft Excel Requires Named Range
| Modification Type: | Major | Last Reviewed: | 5/20/2003 |
|---|
| Keywords: | kbinterop kbprb KB204937 |
|---|
|