| Date: | Tue, 9 Nov 1999 15:04:04 -0500 |
|---|
| Reply-To: | Barbara Okerson <TNPRO.BOkerson@SDPS.ORG> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Barbara Okerson <TNPRO.BOkerson@SDPS.ORG> |
|---|
| Subject: | dde from MS/Access to SAS |
|---|
|
|
| Content-Type: | text/plain |
|---|
We are running SAS 6.12.
We have been using SAS and DDE to transfer data from MS/Access to
SAS. The ODBC driver is not licensed and is not an option for us. We
now have upgraded or are in the process of upgrading MS/Access to
MS/Access 97. Access 97 imposes a 2 gigabyte limit on the buffer
when using dde. This was not a limitation in the previous version of
Access. Has anyone found a way around this buffer limit? Our data
sets average about 3.5 gigabytes.
Thanks in advance.
Barbara
------------------------------------------------------------------------------------
Barbara B. Okerson, Ph.D.
Biostatistician/Health Care Data Analyst
Mid-South Foundation for Medical Care Inc.
6401 Poplar Ave, Suite 400
Memphis, TN 38119
(901) 682-0381 ext 304
| 
