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