Problem Note 52835: Exporting to Microsoft Access files puts incorrect data into the file when there are dates in the first column
 |  |  |  |  |
When you are using the ACCESSCS engine to create MDB or ACCDB files, the data that is written to Microsoft Access files might be incorrect.
The problem occurs when there is a large volume of data and the first column of the SAS data written to the Microsoft Access file contains a date. The problem occurs because of a buffering issue in the SAS® PC Files Server itself.
To resolve the problem, you need to control the buffering that is used to export to this type of file. Use the DBDSOPTS='Insertbuff=1' parameter as shown below:
proc export data=sasdata
outtable="my-table"
dbms=accesscs replace;
database='c:\my-directory\my-file.accdb';
dbdsopts='Insertbuff=1';
quit;
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft Windows Server 2003 Enterprise Edition | 9.3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.3 | 9.3 TS1M0 | ||||
| Microsoft® Windows® for x64 | 9.3 | 9.3 TS1M0 | ||||
| Microsoft Windows Server 2003 Standard Edition | 9.3 | 9.3 TS1M0 | ||||
| Microsoft Windows Server 2003 for x64 | 9.3 | 9.3 TS1M0 | ||||
| Microsoft Windows Server 2008 | 9.3 | 9.3 TS1M0 | ||||
| Microsoft Windows Server 2008 R2 | 9.3 | 9.3 TS1M0 | ||||
| Microsoft Windows Server 2008 for x64 | 9.3 | 9.3 TS1M0 | ||||
| Windows 7 Enterprise x64 | 9.3 | 9.3 TS1M0 | ||||
| Windows 7 Home Premium x64 | 9.3 | 9.3 TS1M0 | ||||
| Windows 7 Professional x64 | 9.3 | 9.3 TS1M0 | ||||
| Windows 7 Ultimate x64 | 9.3 | 9.3 TS1M0 | ||||
| Windows Vista for x64 | 9.3 | 9.3 TS1M0 | ||||
| 64-bit Enabled AIX | 9.3 | 9.3 TS1M0 | ||||
| 64-bit Enabled HP-UX | 9.3 | 9.3 TS1M0 | ||||
| 64-bit Enabled Solaris | 9.3 | 9.3 TS1M0 | ||||
| HP-UX IPF | 9.3 | 9.3 TS1M0 | ||||
| Linux | 9.3 | 9.3 TS1M0 | ||||
| Linux for x64 | 9.3 | 9.3 TS1M0 | ||||
| Solaris for x64 | 9.3 | 9.3 TS1M0 | ||||
A fix for this issue for SAS/ACCESS Interface to PC Files 9.3_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J37.html#52835
Microsoft MDB and ACCDB files can contain incorrect information when writing large volumes of data using the ACCESSCS driver. The problem occurs because of buffering problems in the SAS® PC Files Server.
| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2014-05-22 13:04:54 |
| Date Created: | 2014-04-28 14:58:43 |