Date:         Tue, 4 Jun 2002 13:51:37 -0400
Reply-To:     William Lu <luwp@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         William Lu <luwp@HOTMAIL.COM>
Organization: Bell Sympatico
Subject:      Re: MSAccess97 to SAS V8.2 PC Import of 56k memo fields

Hi Paul,
The memo data type in Access can hold up to 64000 chars.
Proc import has limit for memo, which is 32767. So if your memo is langer
than 32767, proc import will have trouble.(I haven't tested it. As all the
memo I have is less than 32767)
Regards,William
e.g
PROC IMPORT OUT=table1
            DATATABLE=Table1
            DBMS=ACCESS97 REPLACE;
     DATABASE="c:\db1.mdb";
     MEMOSIZE=32767;
RUN;


"paul" <pchoate@DDS.CA.GOV> wrote in message
news:200206041657.g54Gvjq07015@listserv.cc.uga.edu...
> Hi all -
>
> I'm using Proc Import to bring in MSAccess97 tables into SAS v8.2.
> The problem is that I have some memo fields with a upper limit of
> 65,535 bytes, but SAS Proc Import stops importing the fields at 1024
> bytes.  Any ideas how I can get SAS to bring in the full memo fields
> into a SAS ds, without exporting it out of MSAccess first?  I don't
> see any MSAccess97 documentation on Proc Access, and the Proc Import
> documentation is sparse.
>
> thanks for the help...