Date:         Thu, 29 Jun 2000 12:53:22 -0600
Reply-To:     Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Subject:      Re: SAS (UNIX) to Access 9x/2000
Comments: To: chalissery@HOTMAIL.COM
Content-Type: text/plain; charset=us-ascii

"George Chalissery" <chalissery@HOTMAIL.COM> wrote:

>Is there a better way to do this? SAS/Access to PC file formats (for UNIX)
>does not handle Access databases, does it? It does not make sense for me to
>spend money and license SAS/Connect and SAS for Windows and then go from
>Access to SAS via DDE/COM/ODBC and from SAS for Windows to SAS for UNIX
>using Connect. I am considering installing Data Junction on a Windows PC and
>using it to convert between Access and SAS XPORT format. I have also tried
>my hand at StatTransfer and DBMSCopy. They can do the job better than my CSV
>solution, but not seamlessly.

What do you mean by "seamlessly"?

I haven't tried it, but I think you could write a VBA program in Access which
would transfer a file from the Unix machine, convert it to Access format using
DBMS/COPY, and import it into an MDB file.  Error detection in the FTP and
DBMS/COPY steps would be the tricky part.

'Twould be good if DBMS/COPY supported ActiveX Automation.