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
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.