Problem Note 18553: Import Data task might fail to read all Microsoft Excel rows using SAS®
Enterprise Guide®
Certain Microsoft Excel files might not import properly in SAS
Enterprise Guide. In some cases rows of data can be missing, and in some
cases the number of rows is increased. This can occur when the data
contains LF and CR characters. In some cases the problem occurs because
one or more columns have missing values for the first eight or more
rows.
To circumvent the problem, apply the latest hotfix for the version of
SAS Enterprise Guide you are using, then change the following registry
setting:
Start ► Run ► Regedit ►
HKEY LOCAL MACHINE\Software\Microsoft\Jet\4.0\Engines\Excel
then change TypeGuessRows from 8 to 0 (zero).
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS Enterprise Guide | Microsoft Windows XP Professional | 4.1 | | 9.1 TS1M3 SP1 | |
| Microsoft Windows 2000 Professional | 4.1 | | 9.1 TS1M3 SP1 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2006-10-18 15:13:28 |
| Date Created: | 2006-09-19 13:36:27 |
